Thread: Toggle Button
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NavEx
 
Posts: n/a
Default Toggle Button

Purpose: Wants to apply two different formulas in a cell, not simultaneously
Question: How can I use a toggle button to apply different formulas to a
cell or array?
Example: Difference of two values - Number and Percentage
or
Formula calculating yearly profit for 1st, 2nd, 3rd.............. year
and
formula calculating accumulated profit for 1st, 2nd, 3rd ............year