Excel Nested IF Functions

I need help with a nested if function. I cannot get the formula to produce the correct result. The worksheet is attached.

Please help!

AttachmentSize
TEST.xlsx11.16 KB
Nick's picture

=IF(A2<2500,2,IF(A2<4300,3,IF

=IF(A2<2500,2,IF(A2<4300,3,IF(A2<6500,4,IF(A2<8900,5,IF(A2<13000,6,IF(A2<19000,8,IF(A2<33000,10,IF(A2<68000,15,20))))))))