View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gardfd Gardfd is offline
external usenet poster
 
Posts: 3
Default 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