Thread: A text to appear on a mandatory cell
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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


Reply With QuoteReply With Quote