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