Home » Forums » Open Source Learning Center » Question and Answer

Excel Nested IF Functions

Submitted by jramirez on 16 August, 2012 - 15:36

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
‹ OnEntry, Worksheets_change question Download File from Url and SaveAs Overwrite if Exists ›
»
Nick's picture

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

Submitted by Nick on 16 August, 2012 - 15:45.

=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))))))))

»