=if formulae

[Janie]

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.

 

[Joe User]

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(A1>0,A2=0), "ERROR", "")


----- original message -----

 

[ozgrid.com]

=IF(AND(A1>0,A2=0),"ERROR","")