Forum Discussion
Toggle button
Need to create a toggle or switch button to select between two formulas for a single cell output.
Button to apply repeat investor discount
the two formulas:
Button not selected (Discount)
=L56/$O$9
Button selected (Discount Applied)
=L56/$N$9
1 Reply
Let's say you want the "toggle" in cell O1. Select this cell.
Activate the Insert tab of the ribbon, and click Check Box in the Controls group.
Use the following formula in another cell:
=L56/IF($O$1, $N$9, $O$9)
