View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bee Bee is offline
external usenet poster
 
Posts: 46
Default IF STATEMENT Range

Hello, I am trying to put a range in an if statement '0-50', how do I do this
please?
It's as follows:

=IF(AI7 'is between 1:50',(AB7*AI7/100),AI7)
Thanks