One other option I just realized, is that the words MINIMUM or MAXIMUM
may be contained within other text (e.g. "Value is MINIMUM")....

=IF(NOT(ISERROR(FIND("MINIMUM",A1)0)),IF(C1=B1," YES","NO"),IF(NOT(ISERROR(FIND("MAXIMUM",A1)0)),I F(C1<=B1,"YES","NO"),"N/A"))

note that the FIND function IS case sensitive. MINIMUM, minimum and
Minimum are all different and, in my example, only MINIMUM will return
the desired answer. The others will return "N/A".

this can be overcome by using SEARCH instead of FIND, as such:

=IF(NOT(ISERROR(SEARCH("MINIMUM",A1)0)),IF(C1=B1 ,"YES","NO"),IF(NOT(ISERROR(SEARCH("MAXIMUM",A1)0 )),IF(C1<=B1,"YES","NO"),"N/A"))


HTH

Bruce


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=392939