Help writing IF function

Hello,

I need help with nested if function as per below.

If J17 falls between 25-29, then in I want to return 2
If J17 falls between 30-39, then in I want to return 3
If J17 falls between 40 plus, then in I want to return 4

How can I write this out?
Thanks

give this a try

Please Login or Register  to view this content.

Thanks for the quick reply, this works nicely!!
Thanks

no problem---glad I could help....

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...

Ok, I need throw a twist to this now, what you gave will works for a total value, can we do this for an average day instead? My Manager just came to me and would prefer an average instead.

So, if the driver works 3 days and does 15 loads, then he averaged 5 hauls per day and would get $2/load.

Average 5-5.9/day= $2
Average 6-7.9/day=$3
Average >=8/day=$4

Thanks

what column is the average in?...adjust the IF statement to something like this.

Please Login or Register  to view this content.

that should work depending on where the average is located...OR do you have to calculate the average and you need help with that?

judgeh59,

The average will be the total value in J17. If formula as you have with average within it.
Is that possible?

Wonderful guys,

I decided to add in a cell which will calculate the average in addition to the total, so I am good to go!
Thanks

glad we could help....thanks for the rep points