| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0! Error......why is it ignoring the ' Otherwise "" ' ?
Hi all,
I have the following function: =IF($E130,SUM(G13/(((($E13/2)/0.0393700787)*(($E13/2)/0.0393700787)*3.14159265)*$B13/0.0393700787)),IF($E13=0,SUM(G13/(($B13/0.0393700787)*($C13/0.0393700787)*($D13/0.0393700787))),"")) All works fine when there are values filled into B,C and D13, or B & E13. Thats great, as intended...but....when there is no value in B13,C13,D13 or E13, I get the error #DIV/0! in my cell. Why is the very end part of my function, the ' Otherwise "" ' [,""] not working? I need it to just show a blank cell when there are no numbers in B,C,D or E13? Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate average value in a row ignoring values below "x" | Excel Discussion (Misc queries) | |||
| Need help with formula to average numbers while ignoring "0" value | Excel Worksheet Functions | |||
| "ignoring" hidden cells in a copy/paste operation | Excel Discussion (Misc queries) | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Threaded Mode
