| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Use Of If Function
I am trying to use this formula but am unable to get the result as excel gives a message "too many functions" can some one help me with this
=IF(D21180000,D21*0.5%,IF(D21250000,D21*0.75%,IF (D21350000,D21*1.5%,IF(D21400000,D21*2.5%,IF(D21 450000,D21*3.5%,IF(D21550000,D21*4.5%,IF(D21650 000,D21*6%,IF(D21750000,D21*7.5%,IF(D21900000,D2 1*9%,IF(D211050000,D21*10%,IF(D211200000,D21*11% ,IF(D211450000,D21*12.5%,IF(D211700000,D21*14%,I F(D211950000,D21*15%,IF(D212250000,D21*16%,IF(D2 12850000,D21*17.5%,IF(D213550000,D21*18.5%,IF(D2 14550000,D21*19%,IF(D218650000,D21*20%)))))))))) ))))))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Threaded Mode
