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.
