IF Function (WS), multiple conditions

Highlighted
Occasional Visitor

I have to calculate what is the revenue from each rented room. The revenue is dependent on two things:

1) If the room has been booked in advance or on place (plan or on_place)

2) If it is with 1 bed, 2 beds, 3beds, or 4 beds (one,two,three,four)

Prices are as follow:

plan: 

1 bed - $5, 2 beds - $5, 3 beds - $7, 4 beds - $7

on_place:

1 bed - $6, 2 beds - $6, 3 beds - $8, 4 beds - $8

Will it be possible to write an IF statement in order to calculate this and what are the alternatives?

 

Thanks.

0 Replies