if this equals that

M

MAML

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.
 
M

Marcelo

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

hope this helps
Regards from Brazil
Marcelo

"MAML" escreveu:
 
Top