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.