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.

"BriSwy" wrote:

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