Number range in IF formulas

[Airradiator]

Hourly pay is dependent on age as shown below. I have 2 fields setup in my table: 'Age' and 'Hourly Pay'.

I've tried all combos of IF, nested IFs and <= symbols but can't get the formula for all 3 age/pay combos to display correctly. Your help is needed folks..! 

23 and over	21 to 22	18 to 20
£9.50	£9.18	£6.83

[Cindy_Liu · Accepted solution]

Try this formula: IF(Age<18,"",(IF(OR(Age=21,Age=22),'£9.18',IF(Age>22,'£9.50',IF(Age<21,'£6.83',"")))))