if this equals that
 

I am trying to come up with a spreadsheet where if you either type in a X in
A2 ... in column C you will get 10. Then say if you leave A3 blank.. in
column C it will be 0.

if this equals that
 

Hi, try if(a2<"",10,0)

hope this helps
Regards from Brazil
Marcelo

"MAML" escreveu:

I am trying to come up with a spreadsheet where if you either type in a X in
A2 ... in column C you will get 10. Then say if you leave A3 blank.. in
column C it will be 0.

if this equals that
 

=if(A2="X",10,0)

"MAML" wrote:

I am trying to come up with a spreadsheet where if you either type in a X in
A2 ... in column C you will get 10. Then say if you leave A3 blank.. in
column C it will be 0.