I have tried a number of formulas but don't get it right. I'm after:
iF A1 is greater than 0 but less than 29, 1
IF A1 is greater than 30 but less than 100, 2
IF A1 is greater than 100 but less than 200, 3 etc
Assistance certainly appreciated
Thanks
iF A1 is greater than 0 but less than 29, 1
IF A1 is greater than 30 but less than 100, 2
IF A1 is greater than 100 but less than 200, 3 etc
Assistance certainly appreciated
Thanks