"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

"What-if" formula for either a manual entry and automated entry
 

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

"What-if" formula for either a manual entry and automated entr
 

The formula you suggested created a circular reference warning and deleted
the formula
--
MZ


"Niek Otten" wrote:

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

"What-if" formula for either a manual entry and automated entr
 

Not if you entered it in B1, as I suggested

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MZ" wrote in message
...
The formula you suggested created a circular reference warning and deleted
the formula
--
MZ


"Niek Otten" wrote:

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