AnsweredAssumed Answered

If Statement with Multiple Variables

Question asked by MJ_2 on Apr 11, 2012
Latest reply on Apr 11, 2012 by philmodjunk

Title

If Statement with Multiple Variables

Post

HELP.  I can't get the following If ( test ; resultOne ; resultTwo ) to work.

I'm trying to say If client selects "Double Inside" option, then the fee is $1,000...If "Double Oceanview", then the fee is $1,200...If "Triple Oceanview", then the fee is $1,175...If "Quad Oceanview", then $1,100.  

 

This is what I entered...

If ( Cabin Type = "Double Inside" or "Double Oceanview" or "Triple Oceanview" or "Quad Oceanview" ; 1000; 1200; 1175; 1100)

However, I received an error message, please advise.

Thanks in advance.

Outcomes