View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mary S Mary S is offline
external usenet poster
 
Posts: 1
Default How do I use 'between' 95% and 100% for a nested IF function?


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,