pulling info from 2 cels

[manickmj]

What I am trying to do is have one cell read two other cells to
determine if a bonus was earned.

Here is what I need:

I need to have cell c1 read cell a1 and see if it is greater than 9,
also it needs to see if cell b1 is greater or equal to 1. If both cell
match then c1 should read $50.00, if not it is $0.

Thanks in advance
Mike Manick

 

[kkknie]

In C1 type:

=IF(A1>9,IF(B1>=1,50,0),0)

Basically, a nested IF.

 

[Frank Kabel]

Hi
try
=50*(A1>9)*(B1>=1)

 

[mzehr]

Hi
Try the following formula in c1:

=if(And(B1>=1,A1>9),50,0)