What does "it doesn't work" mean to you?

Including your values in quotes makes them Text, but they should still
show up. Remove the quotes for numeric values, or use XL's implicit
conversion of TRUE/FALSE to 1/0 in math formulas:

= --(A3 < 1)



In article ,
"Roze" wrote:

I tried doing the follwing formula but it doesn't work;
=IF(A3=1,"0","1")