=if(and(ai71,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)



Bee wrote:

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

--

Dave Peterson