A text to appear on a mandatory cell
 

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

A text to appear on a mandatory cell
 

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

"lawre" wrote:

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

A text to appear on a mandatory cell
 

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


Gord Dibben MS Excel MVP

On Fri, 23 May 2008 23:53:00 -0700, lawre
wrote:

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

A text to appear on a mandatory cell
 

Actually, you don't need the OR

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


Gord

On Sat, 24 May 2008 07:38:37 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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


Gord Dibben MS Excel MVP

On Fri, 23 May 2008 23:53:00 -0700, lawre
wrote:

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