Hello,
I am planning a prom on Excel and I must calculate all of the costs of the prom.
I am trying to create a drop-down list which features all 3 available prom venues that can be selected. Upon changing the venue, I would like it to also change the price in the cell next to it. Basically if I select Venue X it should cost $40 and if I select Venue Y it should cost $80.
Would this be possible?
Thanks,
I am planning a prom on Excel and I must calculate all of the costs of the prom.
I am trying to create a drop-down list which features all 3 available prom venues that can be selected. Upon changing the venue, I would like it to also change the price in the cell next to it. Basically if I select Venue X it should cost $40 and if I select Venue Y it should cost $80.
Would this be possible?
Thanks,