#DIV/0! - how to get rid of it
 

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?

#DIV/0! - how to get rid of it
 

Try this in H3

=IF(ISBLANK(F3),"",G3/F3)



"Douglas @ Helpdesk" wrote:

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?

#DIV/0! - how to get rid of it
 

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

#DIV/0! - how to get rid of it
 

=IF(F3=0,0,G3/F3)

or

=IF(F3=0,"",G3/F3)


the former returns a zero the latter a blank


--


Regards,


Peo Sjoblom



"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?

#DIV/0! - how to get rid of it
 

Try this:

=IF(OR(F3="",F3=0),"",G3/F3)

Hope this helps.

Pete

On Nov 27, 6:30 pm, Douglas @ Helpdesk
wrote:
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?

#DIV/0! - how to get rid of it
 

You could trap for just F3 being empty

=IF(F3="","",G3/F3) but that would leave a 0 if F3 was filled and G3 was empty

Or trap for either being empty

=IF(OR(F3="",(G3="")),"",G3/F3)


Gord Dibben MS Excel MVP


On Tue, 27 Nov 2007 10:30:02 -0800, Douglas @ Helpdesk
wrote:

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?

#DIV/0! - how to get rid of it
 

Thank you all for your help. It worked. Thank you once again

"Douglas @ Helpdesk" wrote:

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?

#DIV/0! - how to get rid of it
 

Beginning with Excel 2007...

=IFERROR(G3/F3,"")

- -
HTH
Dana DeLouis


"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?