M
MZ
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?})
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?})