| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| force entry in cell "B" if entry made in cell "A" | Excel Discussion (Misc queries) | |||
| I saw this formula entry "=+D20/60 + C20"; what does the "=+" do? | Excel Discussion (Misc queries) | |||
| Formula to confirm entry in Col "C" is valid for data in Col "A" | Excel Discussion (Misc queries) | |||
| need to substitute formula result from #### to"CHECK YOUR ENTRY" | Excel Discussion (Misc queries) | |||
| Formula entry using "+" causing format errors | Excel Discussion (Misc queries) | |||
Linear Mode
