Greetings,
I need to create a calculated column based on the following:
IF[Lodging] ="On-Campus" [Number of Students] + [Number of Instructors]*$1,200.00
IF[Lodging] ="Off-Campus" [Number of Students] + [Number of Instructors]*$1,500.00
IF[Lodging] ="Non-EMI Facility" [Number of Students] + [Number of Instructors]*$1,800.00
I don’t know if its an “IF” statement or not. I basically would like data entered from the columns in [] above to calculate based on the formula or one that will actually work to a separate column that I will name “cost assumptions” in currency format. The goal is to total the cost assumption column up automatically in Sharepoint as a running tracker that can be filtered by Cadre.
any help would be appreciated...
v/r
novice