Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get rid of #DIV/0!
Hi,
How do I get rid of #DIV/0! in my cell when I used the following formula? =IF(Q3="","",1-(Q3/F3)) I have tried everything and it still shows up in my cells that use this formula. thanks for anyhelp that you can give me. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get rid of #DIV/0!
It sounds like F3 = 0, is blank or is not numeric. In each case, Excel sees
its numeric value as 0, therefore a divide by zero error. Ian wrote in message oups.com... Hi, How do I get rid of #DIV/0! in my cell when I used the following formula? =IF(Q3="","",1-(Q3/F3)) I have tried everything and it still shows up in my cells that use this formula. thanks for anyhelp that you can give me. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get rid of #DIV/0!
What is in F3? An empty cell? A zero?
If empty cell then try: =IF(OR(Q3="",F3=""),"",1-Q3/F3) If F3 contains 0 then use: =IF(OR(Q3="",F3=0),"",1-Q3/F3) Note that you don't need the inner parentheses because XL's precedence of operation is multiplication/division then addition/subtraction. If the parentheses are for clarity then leave them because they are doing no harm. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk wrote in message oups.com... Hi, How do I get rid of #DIV/0! in my cell when I used the following formula? =IF(Q3="","",1-(Q3/F3)) I have tried everything and it still shows up in my cells that use this formula. thanks for anyhelp that you can give me. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get rid of #DIV/0!
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get rid of #DIV/0!
=IF(AND(ISNUMBER(F3),F30,Q3<""),1-(Q3/F3),"")
" wrote: Hi, How do I get rid of #DIV/0! in my cell when I used the following formula? =IF(Q3="","",1-(Q3/F3)) I have tried everything and it still shows up in my cells that use this formula. thanks for anyhelp that you can give me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|