Please help with if then statement

I would like to add a multi condition if then statement to my worksheet and I am missing the boat.
I am calculating the full time equivalent of employees. So I enter the employment code and how many people fit that catagory per region and I want to put in an if/then that will tell me how many full time it equals...making any sense?

part time professional = 1-50
part time associate = 2-50
a region has 40 employees so 20 "full time equivalents"

there are several associates and professionals from 25%-100% employment...I am stuck

can we see an spreadsheet with examples and expected results

i dont quite understand the example you have put in your post

you have an employment code and number of people - mot sure how you decide what a FTE is

a region has 40 employees so 20 "full time equivalents"

not sure how you came to that calc

Attached...thanks, I hope it helps

If the employment code is 1-50 or 2-50 it is a part time employee and it will take two part timers to equal one full time equivalent so 40 2-50's would be 20 FTEs or if they same employees are employed at 25% (1-25 or 2-25) it would be 10 FTEs

I want a function or macro that will show this caluclation in "I". What ever employment code is in C will be equal to the value in E*% of employment (25%, 50%, 100%). Can I do this for the whole worksheet?

I will look at spreadsheet in the meantime

so the 2nd part of the code is the %

assume row 2
=IF(OR(C2="1-100",C2="2-100"),E2,IF(OR(C2="1-50",C2="2-50"),E2*0.5,IF(OR(C2="1-25",C2="2-25"),E2*0.25,"not a valid code")))

Yes...second part of the code is the % worked. I wasn't sure how an OR/AND fit into the formula. I am a pretty basic girl this is a little out of my comfort zone

looked at the sheet

How many codes are there -
AC-1-100
AC-1-25
AC-1-50
AC-2-100
AC-2-25
AC-2-50
FP-1-100
FP-2-100
FP-2-25
FP-2-50
PM-0-0
PM-1-0
PM-2-0

and can we assume that the last figure is the FTE % -does that work for all- what about PM codes ?

the last figure is the % and the only codes I need to calculate are the AC codes

this should work

=IF( MID(C2,1,2)="AC", VALUE(MID(C2,6,3))/100*E2, "what to put for Non AC codes")

so
I test the code in C2 to see if the first 2 characters are AC
if they are
than E2 is muliplied by
i take the last 2or 3 characters from the text in c2
I then use value to turn the text into a number
then divide by 100 to make a %

but if not AC code what do you want in the cell?

if not an AC code it can be zero. I will wrap my brain around this and give it a go. I really appreicate the help

in which case
=IF( MID(C2,1,2)="AC", VALUE(MID(C2,6,3))/100*E2, 0)

see attached


if you want the cell left blank
=IF( MID(C2,1,2)="AC", VALUE(MID(C2,6,3))/100*E2, "")