ExcelBanter - HIDING DIV/0!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HIDING DIV/0! (https://www.excelbanter.com/excel-discussion-misc-queries/76146-hiding-div-0-a.html)

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

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

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