Excel - IF formula to get a percentage increase

Asked By Carolin on 14-May-08 02:43 PM
```I need a formula (IF maybe) that will result in an increase amount. I have
several types of service care (I,II,III) as drop down option on column G.
Those same types of service have been assigned a percentage (1%,2%,3%) on
column AF
For example, If someone selects service care "I" the formula should locate
the respective percentage for that level (1%) and then use this percentage to
calculate a dollar amount increase with respect to a dollar amount on column
AA

Column G     Column AA Column AF   Result
Drop Down       100            1%         \$1.0
Drop Down       200            2%         \$4.0
Drop Down       300            3%         \$9.0```

Carolin replied on 14-May-08 03:35 PM
```I figured it out so I thought I share:
=IF(G23=AE\$3,(AA23*AF\$3),IF(G23=AE\$4,(AA23*AF\$4),IF(G23=AE\$5,(AA23*AF\$5),IF(G23=AE\$6,(AA23*AF\$6),IF(G23=AE\$7,(AA23*AF\$7),IF(G23=AE\$8,(AA23*AF\$8)))))))```
Niek Otten replied on 14-May-08 04:04 PM
```Hi Carolina,

Good that you got it working.
Be aware that there is a limit to the nesting of functions; 7 levels is the maximum.

Have a look at the VLOOKUP() function.
There's a tutorial here:

http://www.contextures.com/xlFunctions02.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

=IF(G23=AE\$3,(AA23*AF\$3),IF(G23=AE\$4,(AA23*AF\$4),IF(G23=AE\$5,(AA23*AF\$5),IF(G23=AE\$6,(AA23*AF\$6),IF(G23=AE\$7,(AA23*AF\$7),IF(G23=AE\$8,(AA23*AF\$8)))))))```