IF STATEMENT Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=if(and(ai7>1,ai7<50),(ab7*ai7)/100,ai7)

But I'm not sure what happens at 1 and 50.

You may want:

=if(and(ai7>=1,ai7<=50),(ab7*ai7)/100,ai7)
 
Thanks for that, perfect. Another question, do you know how to do a
conditional format for a cell that is <50 to display as % and if >50 show
just a decimal number. Thanks again.
 
You have a reply at your other post.
Thanks for that, perfect. Another question, do you know how to do a
conditional format for a cell that is <50 to display as % and if >50 show
just a decimal number. Thanks again.
Click to expand...
 
Back
Top