IF OR Question

I'm trying to calculate a Total Amount column where if the Type field is either Faculty or EMT then the Total Amount equals Total Meals * 100 (each meal costs $100), but otherwise is $0. I keep getting errors with this:

=IF(OR(Type@row, "Faculty", Type@row, "EMT", [Total Meals]@row * 100, 0))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!