I would say if A1 is empty, use the result of the formula in A2, else use
what is in A1.
B1:
=IF(A1="",A2,A1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"MZ" wrote in message
...
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