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

On Nov 24, 6:37*pm, ibrokit wrote:
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

Sorry, slight mistake:

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

Hope this helps.

Pete

On Nov 24, 6:48*pm, Pete_UK wrote:
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

On Nov 24, 6:37*pm, ibrokit wrote:



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- Hide quoted text -

- Show quoted text -

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

--
Greetings from New Zealand


"ibrokit" wrote in message
...
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

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
if I = "session" then f*h
if I = "person" then e*f*h


"ibrokit" wrote:

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

Bill Kuunders wrote:
=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