Elseif?

  • Thread starter Thread starter ibrokit
  • Start date Start date
I

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
 
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
 
Sorry, slight mistake:

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

Hope this helps.

Pete
 
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
 
Bill said:
=if(I3="hour",F3*G3*H3,if(I3="session",F3*H3,E3*F3*H3))
should do it
Click to expand...
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
 
Back
Top