Thread: How do I use 'between' 95% and 100% for a nested IF function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
  
Posts: 834
Default How do I use 'between' 95% and 100% for a nested IF function?
Try

=IF(AND(Q2=95%,Q2<=100%),2,6)

--

HTH

Bob

"Mary S" <Mary wrote in message
...

I need an excel formula which claculates 'between' 95% and 100% i.e.

If( O2= between 95% and 100%, 1 x 2, 2 x 3)

I need nested IF functions,


Reply With QuoteReply With Quote