Need help with text variables = Formulas*

[Hodgo]

Hi all,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I've been tearing our my hair trying to figure out a solution for my work spreadsheet problem of which I've been using only my high school taught excel knowledge with no success... *sigh*. Hopefully someone here can help .<o></o>
<o></o>
First of, small background knowledge relevant to spreadsheet: I work in recruitment where we need a spreadsheet that can calculate the total of what the market would charge... hopefully by seeing how to logically create a formula like this I'll be able to form a formula for our Fees (almost half of what the market offers).<o></o>
<o></o>
<o></o>
First of there are Three Possible variables in cell $E2 (column name: "Type of Position")<o></o>
· Permanent<o></o>
· Contract<o></o>
· Extension<o></o>
<o></o>
Each "Type of Position" will need to have separate formulas in cell $T2 (column Market Rates) now I want to have a standard formula which incorporates each of the below so my account managers can just copy & paste down each row;<o></o>
· Permanent: $L2 (Salary) x 15%<o></o>
· Contract: 40(hr/wk) x $O2(Number of Weeks in separate column) x 15 (standard hr rate)<o></o>
· Extension: to just display "Extension" in $T2<o></o>
<o></o>
Now I would prefer to use IF then using VLOOKUP Key below just to keep it more compacted.<o></o>
<o> </o>
I know this is allot to ask but any help received is extremely appreciated<o></o>

Thanks
Hodgo

 

[asking]

Try ~

=IF($E2="Permanent",$L2*15%,IF($E2="Contract",$O2*40*15,IF($E2="Extension","Extension","")))

Cheers

 

[Hodgo]

Brilliant, that works perfectly.

Thanks Mate