=IF(A1="","",IF(A1=0,0,<formula))



OBlake wrote:

I am trying to evaluate a cell and return zero if zero is put into the cell,
blank if the cell is left blank and evaluate a formula if a number other then
zero is entered.
I have tried:
=IF(AJ7=0,0,(Formula) with and without conditional formating 0;-0;;@
as well as
=IF(AJ10=0,0,IF(AJ10=",",",",(Formula)))
as well as
=IF(AJ10=0,0,IF(AJ10="","",(Formula)))
It seems that a blank cell and a cell with a '0' in it are treated the same??
Does anyone have anymore ideas?


--

Dave Peterson