Hello everyone,

I would like to use a sliding scale feature that shows the result based on changing the variables I have in the formula. I have never used sliding scale before.

# of events/month (cell b7) 8 - Constant
Avg guest list transactions (cell b8) 10 - Variable ( range I want - 5 t0 50)
Guest list fill in rate (cell b9) 50% - Variable ( range I want - 10% - 100%)

I am trying to get total guest list transaction (B7*b8*b9) using the sliding scale. Any help on how to implement sliding scale on the spreadsheet would be greatly appreciated.

Thank you.
Arpit