Thread: greater than, less than, and in between
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Dena Dena is offline
external usenet poster
  
Posts: 12
Default greater than, less than, and in between
Thanks it worked!!!!!.

"TomPl" wrote:

You would get "False" on values between 94 and 95. Try this:

=IF(C6100%,"HIGH",IF(C6=95%,"WARNING","GOOD"))

Tom
Reply With QuoteReply With Quote