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
|