Help

Number range in IF formulas

Topic Labels: Formulas
Solved
Jump to Solution
534 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Airradiator
4 - Data Explorer
4 - Data Explorer

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 over21 to 2218 to 20
£9.50£9.18£6.83

 

1 Solution

Accepted Solutions
Cindy_Liu
4 - Data Explorer
4 - Data Explorer
Try this formula: IF(Age<18,"",(IF(OR(Age=21,Age=22),'£9.18',IF(Age>22,'£9.50',IF(Age<21,'£6.83',"")))))

See Solution in Thread

1 Reply 1
Cindy_Liu
4 - Data Explorer
4 - Data Explorer
Try this formula: IF(Age<18,"",(IF(OR(Age=21,Age=22),'£9.18',IF(Age>22,'£9.50',IF(Age<21,'£6.83',"")))))