| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
New Display Problem
I have this formula in Column "D" =(E5/B5)*100 E5 is 0.00 and B5 is Blank. D5 displays #DIV/0! What have I done wrong? old dog learning new tricks  -- bluenoser1946 ------------------------------------------------------------------------ bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006 View this thread: http://www.excelforum.com/showthread...hreadid=393688 |
|
#2
|
|||
|
|||
|
=IF(B5=0,"",(E5/B5)*100)
Vaya con Dios, Chuck, CABGx3 "bluenoser1946" wrote in message news:bluenoser1946.1teomj_1123437929.3228@excelfor um-nospam.com... I have this formula in Column "D" =(E5/B5)*100 E5 is 0.00 and B5 is Blank. D5 displays #DIV/0! What have I done wrong? old dog learning new tricks -- bluenoser1946 ------------------------------------------------------------------------ bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006 View this thread: http://www.excelforum.com/showthread...hreadid=393688 |
|
#3
|
|||
|
|||
|
The error showing in D5 shows that you attempted to divide by zero (or blank
which amounts to the same in this case) You could test for this condition (i.e. B5 = 0 or blank) by amending your formula to =IF(OR(B5="",B5=0),"",(E5/B5)*100) which will result in D5 showing blank unless B5 is something other than 0 or "" "bluenoser1946" wrote: I have this formula in Column "D" =(E5/B5)*100 E5 is 0.00 and B5 is Blank. D5 displays #DIV/0! What have I done wrong? old dog learning new tricks -- bluenoser1946 ------------------------------------------------------------------------ bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006 View this thread: http://www.excelforum.com/showthread...hreadid=393688 |
|
#4
|
|||
|
|||
|
Nothing wrong, you can't divide by zero so that is what it is telling you,
you can add this =IF(B5=0,"",(E5/B5)*100) will be blank if B5 is blank or zero, replace "" with 0 if you want zero as an answer -- Regards, Peo Sjoblom (No private emails please) "bluenoser1946" wrote in message news:bluenoser1946.1teomj_1123437929.3228@excelfor um-nospam.com... I have this formula in Column "D" =(E5/B5)*100 E5 is 0.00 and B5 is Blank. D5 displays #DIV/0! What have I done wrong? old dog learning new tricks -- bluenoser1946 ------------------------------------------------------------------------ bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006 View this thread: http://www.excelforum.com/showthread...hreadid=393688 |
|
#5
|
|||
|
|||
|
Although your formula works and is more sound logically the OR is not needed
since excel see a blank as zero so =0 is enough to test both for blanks and zeros -- Regards, Peo Sjoblom (No private emails please) "bigwheel" wrote in message ... The error showing in D5 shows that you attempted to divide by zero (or blank which amounts to the same in this case) You could test for this condition (i.e. B5 = 0 or blank) by amending your formula to =IF(OR(B5="",B5=0),"",(E5/B5)*100) which will result in D5 showing blank unless B5 is something other than 0 or "" "bluenoser1946" wrote: I have this formula in Column "D" =(E5/B5)*100 E5 is 0.00 and B5 is Blank. D5 displays #DIV/0! What have I done wrong? old dog learning new tricks -- bluenoser1946 ------------------------------------------------------------------------ bluenoser1946's Profile: http://www.excelforum.com/member.php...o&userid=26006 View this thread: http://www.excelforum.com/showthread...hreadid=393688 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
| Excel Display Problem | Excel Discussion (Misc queries) | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
| Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
| Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions | |||
Linear Mode
