IF Formula

Ana Hernandez

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.

Heather Duff

@Ana Hernandez ,

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

Heather Duff

@Ana Hernandez ,

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

Ana Hernandez

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

Heather Duff

@Ana Hernandez Happy to help!