A text to appear on a mandatory cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lawre - 24 May 2008 07:53 GMT

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 to this Message

Mike H - 24 May 2008 10:29 GMT

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

> 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 to this Message

Gord Dibben - 24 May 2008 15:38 GMT

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

Gord Dibben MS Excel MVP

>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 to this Message

Gord Dibben - 24 May 2008 15:57 GMT

Actually, you don't need the OR

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

Gord

>=IF(OR(A1=""),"blank",IF(A1=0,"error",A1))
>
[quoted text clipped - 5 lines]
>>
>>thank you

Reply to this Message