Thread
:
greater than, less than, and in between
View Single Post
#
2
Posted to microsoft.public.excel.misc
TomPl
external usenet poster
Posts: 342
greater than, less than, and in between
You would get "False" on values between 94 and 95. Try this:
=IF(C6100%,"HIGH",IF(C6=95%,"WARNING","GOOD"))
Tom
Reply With Quote
TomPl
View Public Profile
Find all posts by TomPl