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/$...
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)