View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mz mz is offline
external usenet poster
 
Posts: 40
Default "What-if" formula for either a manual entry and automated entry

A formula calculates a tax bracket based upon taxable income and one of four
filing statuses; I would like to be able to either manually enter an amount
of taxable income or have a number that is calculated elsewhere inserted in
the cell; I created a trigger to insert the calculated cell by using an "IF"
statement, but how would I complete the formula to allow for a manual
insertion

A1 is the trigger - If "Yes", then the calculated number that is contained
in cell A2 is entered into B1 (which is the blank cell used for inserting
taxable income)

[Cell B1 formula]=IF(A1="Yes",A2,{What goes here that would allow for
inserting a number manually in B1?})
--
MZ