A text to appear on a mandatory cell

  • Thread starter Thread starter lawre
  • Start date Start date
L

lawre

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
 
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
 
=IF(OR(A1=""),"blank",IF(A1=0,"error",A1))


Gord Dibben MS Excel MVP
 
Actually, you don't need the OR

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


Gord
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to make One Cell mandatory if another cell has a specific value , can anyone help me? 0
Excel Typed text appears in wrong cell 0
Excel Making a cell Mandatory 9
Mandatory/Compulsory 2
Finding Text within an Array 2
Creating a spreadsheet with mandatory fields 0
Mandatory and optional formula 5
TEXT issues 2

Back
Top