Is there a formula if I want 'If blank = 0, if anything entered = 1'

[nicfarrell]

Hi All,

Wondering if you can help with a fairly basic formula question.

I'd like a formula that returns a result of '0' if there is nothing typed in the selected cell, and to return '1 if there is anything. Hoping you can help.

Thanks,
Nic

[Ace_XL]

=if(a1="",0,1)

[nicfarrell]

Thanks so much Ace_XL...worked a treat!