Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Validation and Formula
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation formula | Excel Discussion (Misc queries) | |||
Can I use formula with data validation? | Excel Discussion (Misc queries) | |||
data validation formula | Excel Discussion (Misc queries) | |||
Help with Formula (data validation maybe?) | Excel Programming | |||
Data validation Formula | Excel Discussion (Misc queries) |