Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDING DIV/0!
How can I hide a DIV/1 error? The formula is
=+IF(G37<=79%,"ORDER", "") but when nothing is entered into the columns i get the DIV/0! error. Any help would be appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDING DIV/0!
The error is returned becasue the value of g37 is div/0 so the logic does not evaluate and repeats the error =+IF(ISERROR(G37),"", IF(G37<=75%,"ORDER","")) Would work but a better option would be to tackle the error at source and remove the error from g37 using an if statement that if the denominator (the thing you are dividing by) is 0 to change to another value otherwise do the calculation Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=520504 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HIDING DIV/0!
thanks Dav, it worked a treat...
Cheers Paul "Dav" wrote: The error is returned becasue the value of g37 is div/0 so the logic does not evaluate and repeats the error =+IF(ISERROR(G37),"", IF(G37<=75%,"ORDER","")) Would work but a better option would be to tackle the error at source and remove the error from g37 using an if statement that if the denominator (the thing you are dividing by) is 0 to change to another value otherwise do the calculation Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=520504 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
# DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
hiding #DIV/0! message | Excel Discussion (Misc queries) | |||
#DIV/0! hiding | Excel Discussion (Misc queries) |