Evaluate IF(OR Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gardfd - 20 Sep 2007 17:02 GMT

I was wondering if anyone knows a way to determine which of the "OR"
occurrences triggers the "Error" result. Basically I want to either create a
pop-up box (which I know how to do), or change the font color to alert the
user to an input mistake.

=IF(OR($F$83>$F$84,$F$83>$G$83,$F$83>$F$89,$F$83<$E$83),"Error","")

Thanks
FG

Reply to this Message

Tom Ogilvy - 20 Sep 2007 17:34 GMT

Perhaps this will give you some ideas:

=IF(OR($F$83>$F$84,$F$83>$G$83,$F$83>$F$89,$F$83<$E$83),INDEX({">F84",">G83",">F89","<E83"},1,MATCH(TRUE,CHOOSE({1,2,3,4},$F$83>$F$84,$F$83>$G$83,$F$83>$F$89,$F$83<$E$83),0)),"")

Signature

Regards,
Tom Ogilvy

> I was wondering if anyone knows a way to determine which of the "OR"
> occurrences triggers the "Error" result. Basically I want to either create a
[quoted text clipped - 5 lines]
> Thanks
> FG

Reply to this Message