Elseif?

[ibrokit]

Hey there,

I have a spreadsheet that I need to calculate the total instruction cost
of a vendor. I have 5 columns: Number of students (E) - Number of
sessions (F) - Length of class in hours (G) - Vendor Rate (H) - Charge
by Hour\Session\Person (I).
In my Total Instruction Cost column (J), I need it to calculate based on
what's in the "Charge By" column (I):
So, if I = "hour" then multiply f*g*h
if I = "session" then f*h
if I = "person" then e*f*h

I just haven't figured out how to write the formula for that. Any help?

Thanks so much,

ibk

 

[Pete_UK]

Assuming the first row of data is row 2, then put this in J2:

=IF(I2="hour",H2,IF(I2="person",E2,IF(I2="session",1,0)))*F2*H2

Hope this helps.

Pete

 

[Pete_UK]

Sorry, slight mistake:

=IF(I2="hour",G2,IF(I2="person",E2,IF(I2="session",1,0)))*F2*H2

Hope this helps.

Pete

 

[Bill Kuunders]

=if(I3="hour",F3*G3*H3,if(I3="session",F3*H3,E3*F3*H3))
should do it

 

[Shane Devenshire]

Hi,

=IF(I1="Hours",G1,IF(I1="Person",E1,1)*F1*H1

If this helps, please click the Yes button

Cheers,
Shane Devenshire

So, if I = "hour" then multiply f*g*h

 

[ibrokit]

=if(I3="hour",F3*G3*H3,if(I3="session",F3*H3,E3*F3*H3))
should do it

This is exactly what I ended up doing after I thought it over a little
more. Thanks to you, Pete and Shane for your assistance.

ibk