Hello,

I'm making a hotel worksheet.. I have a dropdown menu at B2 with these
options (Single, Double and Suit), and on C2 I have an Adavance column (If a
guest pays any money in advance).

The prices are as follows Single = 39000, Double = 45000 and Suit = 85000

I want the BALANCE at cell E2 should calculate the BALANCE

e.g If I select "Single" from B2 Drop Menu and the guest has paid ADVANCE
10000, the BALANCE should automatically calculate 39000 - 10000 = 29000. The
same way if I select suit or Double it should consider the room rate and
minus the ADVANCE (if paid) and show the value.

Please help.

Hasnain