| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mandatory Cell Entry | Excel Discussion (Misc queries) | |||
| mandatory cell | Excel Discussion (Misc queries) | |||
| Mandatory cell | Excel Discussion (Misc queries) | |||
| Cell to be mandatory fill in | Excel Discussion (Misc queries) | |||
| How can I make a cell mandatory? | Excel Discussion (Misc queries) | |||
Linear Mode
