AnsweredAssumed Answered

How to Create an "If" Calculation

Question asked by enyko on Oct 12, 2009
Latest reply on Oct 12, 2009 by philmodjunk

Title

How to Create an "If" Calculation

Post

Hi guys,

 

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? 

Outcomes