H
Hasnain
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
(e-mail address removed)
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
(e-mail address removed)