Use this:

=IF(and(AI71,AI7<50),(AB7*AI7/100),AI7)

Hope this helps.


"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