This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Help

Number range in IF formulas

Topic Labels: Formulas
Solved
Jump to Solution
479 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Airradiator
4 - Data Explorer
4 - Data Explorer
See Solution in Thread

‎Mar 02, 2023 06:49 AM

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

 

0 Kudos
Reply
1 Solution

Accepted Solutions
Cindy_Liu
4 - Data Explorer
4 - Data Explorer
Solved See Solution in Thread

‎Mar 02, 2023 09:30 AM

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

Reply
1 Reply 1
Cindy_Liu
4 - Data Explorer
4 - Data Explorer
Solved See Solution in Thread

‎Mar 02, 2023 09:30 AM

Try this formula: IF(Age<18,"",(IF(OR(Age=21,Age=22),'£9.18',IF(Age>22,'£9.50',IF(Age<21,'£6.83',"")))))
Reply
Copyright © 2024 Khoros, LLC