Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |