I was hoping that someone knows a formula for what I want to do. I want to have the F&B per group room night (Budget) to calculate based on the room nights (Row 8) multiplied by the F&B budget (Row 9). but the kicker is that I need a formula that would do the calculation no matter where I put in the room nights.
For example, the formula would work if I put 400 in June and will still work if I put it in September and without changing the formula.
Is this even possible???