if this equals that

[Guest]

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.

 

[Guest]

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

hope this helps
Regards from Brazil
Marcelo

"MAML" escreveu:

 

[Guest]

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