How to Create an "If" Calculation
I'm looking to create a simple calculation that will add up the selections of a given field. For example, rental costs are;
Projector = $360
DVD Player = $50
Screen = $75
My formula is below and only works when you select one item. But it doesn't add up the selections if there are more then one selected.
(If ( Audio Visual = "2000 LM Projector" ; 360)) + (If ( Audio Visual = "DVD Player" ; 50)) + (If ( Audio Visual = "8' Screen & Skirt" ; 75))
What am I doing wrong in this formula?