=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.