If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=if formulae
I have and excel spreadsheet which I wish to record an error message if one
cell as a value of more than zero and the cell below it has a value of zero. I have managed the first part of the formula but can not figure out how if the both cells are zero to return a " " result. |
#2
|
|||
|
|||
=if formulae
"Janie" wrote:
I have and excel spreadsheet which I wish to record an error message if one cell as a value of more than zero and the cell below it has a value of zero. Ostensibly: =if(and(A10,A2=0), "ERROR", "") ----- original message ----- "Janie" wrote: I have and excel spreadsheet which I wish to record an error message if one cell as a value of more than zero and the cell below it has a value of zero. I have managed the first part of the formula but can not figure out how if the both cells are zero to return a " " result. |
#3
|
|||
|
|||
=if formulae
=IF(AND(A10,A2=0),"ERROR","")
-- Regards Dave Hawley www.ozgrid.com "Janie" wrote in message ... I have and excel spreadsheet which I wish to record an error message if one cell as a value of more than zero and the cell below it has a value of zero. I have managed the first part of the formula but can not figure out how if the both cells are zero to return a " " result. |
Thread Tools | |
Display Modes | |
|
|