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