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!
Attachment | Size |
---|---|
TEST.xlsx | 11.16 KB |
ExcelExperts.comExcel Consultancy, VBA Consultancy, Training and Tips Call:+442081234832 |
|
Excel / VBA ConsultancyFree Training VideosFree SpreadsheetsExcel / VBA JobsNavigationWho's onlineThere are currently 0 users and 686 guests online.
New Excel Experts
Current Excel / VBA Jobs |
Excel Nested IF FunctionsI need help with a nested if function. I cannot get the formula to produce the correct result. The worksheet is attached. Please help!
|
Highest Ranked Users
Recent Blogs
ForumsRecent comments
User login |
=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))))))))