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
|