|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 27th, 2007, 06:30 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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? 
|
|
#2
November 27th, 2007, 06:36 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
|
#3
November 27th, 2007, 06:37 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
|
#4
November 27th, 2007, 06:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
|
#5
November 27th, 2007, 06:38 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
|
#6
November 27th, 2007, 06:45 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
|
#7
November 27th, 2007, 07:56 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
|
#8
November 30th, 2007, 01:10 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
