Evaluate IF(OR Statement
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
|