=IF(F3=0,"",G3/F3)
or
=IF(F3=0,0,G3/F3) and uncheck zero values in Tools Options
Regards,
Alan.
"Douglas @ Helpdesk" wrote in
message ...
I have a user that the formula is H3=G3/F3 - where both g3 and f3 are blank
b/c they are not populated. The user wants them there so when the field
would be populated they would fill H3 correctly. The customer doesnt want
to
see #DIV/0! going down the page. How could i fix this issue without having
0
all the way down and still have the functionality when the fields are
populated?