Evaluate IF(OR Statement

[Guest]

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

 

[Guest]

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)),"")