| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
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 |
| 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 | |||
Threaded Mode
