=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