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
>
>