IF Formula
Hi everyone,
I'm having trouble with the IF formula:
what I want to to be able to classify a task depending on the amount of hours that we need to develop it.
so I have this chart:
1  500 hours = 1
500  1000 hours = 2
1000  1500 hours = 3
1500  2000 hours = 4
more than 2000 hours = 5
=IF([Total Hrs]@row < 500, 1, [Total Hrs]@row < 1000, 2, [Total Hrs]@row < 1500, 3, [Total Hrs]@row < 2000, 4, [Total Hrs]@row > 2000, 5)
Could someone please help me? thank you so much.
Best Answer

You're close! Try this:
=IF([Total Hrs]@row < 500, 1, IF([Total Hrs]@row < 1000, 2, IF([Total Hrs]@row < 1500, 3, IF([Total Hrs]@row < 2000, 4, IF([Total Hrs]@row > 2000, 5, "")))))
Let me know if it works!
Best,
Heather
Answers

You're close! Try this:
=IF([Total Hrs]@row < 500, 1, IF([Total Hrs]@row < 1000, 2, IF([Total Hrs]@row < 1500, 3, IF([Total Hrs]@row < 2000, 4, IF([Total Hrs]@row > 2000, 5, "")))))
Let me know if it works!
Best,
Heather

It worked!!! thank you so much :) you're the best!🤩

@Ana Hernandez Happy to help!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 124 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!