Zero if zero yet blank if blank?
Try testing for the empty cell first...
=IF(A7="","",IF(A7=0,0,<<your formula))
Rick
"OBlake" wrote in message
...
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?
|