Nested If Formula

Vanessa Sandom

Could someone please help me with this IF formula? Much appreciated!

=IF([Total Individual Miles]1>350, "Five", IF(Total Individual Miles]1 <= 50, "One", IF(AND([Total Individual Miles]1 >50, [Total Individual Miles]1 <=150), "Two", IF(And([Total Individual Miles]1 >150, [Total Individual Miles]1 <=250, "Three", IF(And([Total Individual Miles]1 >250, [Total Individual Miles]1 <=350, "Four", "")))))

Nic Larsen

Try: =IF([Total Individual Miles]@row > 350, "Five", IF(AND([Total Individual Miles]@row > 250, [Total Individual Miles]@row <= 350), "Four", IF(AND([Total Individual Miles]@row > 150, [Total Individual Miles]@row <= 250), "Three", IF(AND([Total Individual Miles]@row > 50, [Total Individual Miles]@row <= 150), "Two", "One"))))

Nic Larsen

Try: =IF([Total Individual Miles]@row > 350, "Five", IF(AND([Total Individual Miles]@row > 250, [Total Individual Miles]@row <= 350), "Four", IF(AND([Total Individual Miles]@row > 150, [Total Individual Miles]@row <= 250), "Three", IF(AND([Total Individual Miles]@row > 50, [Total Individual Miles]@row <= 150), "Two", "One"))))

Vanessa Sandom

Yippee!! Thanks so much!! Made my day!