A common errorr, and understandable. You have to enter the IF query as:
IF ( Cabin Type = "Double Inside" or Cabin Type = "Double Oceanview" or Cabin Type = "Triple Oceanview" or Cabin Type = "Quad Oceanview" etc...
But the rest of your outcomes suggest that you need a Case Statement (which is generally more versatile than an IF, anyway)
Cabin Type = "Double Inside" ; 1000 ;
Cabin Type = "Double Oceanview" ; 1200 ;
Cabin Type = "Triple Oceanview" ; 1175 ;
Cabin Type = "Quad Oceanview" ; 1100 ;
Thanks a million. I'll try this...
It works, but you may want to set up a table where you have one record for each of these options an their prices and use a relationship so that the price can be looked up automatically when you select a value for cabin type.
With such a pricing table, you can change your rates in the future by updating values on a layout rather than be redefining your calculation field to contain new numbers--which requires developer access and will change the prices of your past cabin rental records to use the new rates---which messes up your business records.