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

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?})
 
N

Niek Otten

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)
 
M

MZ

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


Niek Otten said:
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 said:
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?})
 
N

Niek Otten

Not if you entered it in B1, as I suggested

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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


Niek Otten said:
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 said:
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?})
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top