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
Check out the Formula Handbook template!