A text to appear on a mandatory cell

[lawre]

would appreciate if the forum could enlighten me as to how to formulate a cell.

If Cell A1 is zero then an error text will appear on it

thank you

 

[Mike H]

Hi,

You can't have a formula in A1 that says if
=if(a1=0,"eror",a1)
so it would have to be done by referencing another cells.
How does A1 become zero?

Mike

 

[Gord Dibben]

=IF(OR(A1=""),"blank",IF(A1=0,"error",A1))


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Actually, you don't need the OR

=IF(A1="","blank",IF(A1=0,"error",A1))


Gord