Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Number range in IF formulas

Topic Labels: Formulas
Solved
Jump to Solution
863 1
cancel
Turn on suggestions
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 © 2025 Khoros, LLC
Top