Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link cells
I am doing a tax estimate workbook. It has 3 worksheets-income, deductions
and tax calculation. I want to the income total from the income sheet in the deduction sheet. I can't figure out how to do this without entering the number manually. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link cells
On the sheet where you want the total income, sheet put this formula,
assuming the income is totaled in cell A1 of the Income sheet. =Income!A1 Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I am doing a tax estimate workbook. It has 3 worksheets-income, deductions and tax calculation. I want to the income total from the income sheet in the deduction sheet. I can't figure out how to do this without entering the number manually. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link cells
That worked just fine, thanks. Now I want to take that figure and multiply it
by a constant. I think I am not doing that correctly either because all it leaves in the cell is the formula "CLR" wrote: On the sheet where you want the total income, sheet put this formula, assuming the income is totaled in cell A1 of the Income sheet. =Income!A1 Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I am doing a tax estimate workbook. It has 3 worksheets-income, deductions and tax calculation. I want to the income total from the income sheet in the deduction sheet. I can't figure out how to do this without entering the number manually. Thanks |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link cells
If all you can see in the cell is the formula, then it's probably formatted
as Text, so re-format it to General and re-enter the formula. -- David Biddulph "Jim" wrote in message ... That worked just fine, thanks. Now I want to take that figure and multiply it by a constant. I think I am not doing that correctly either because all it leaves in the cell is the formula "CLR" wrote: On the sheet where you want the total income, sheet put this formula, assuming the income is totaled in cell A1 of the Income sheet. =Income!A1 Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I am doing a tax estimate workbook. It has 3 worksheets-income, deductions and tax calculation. I want to the income total from the income sheet in the deduction sheet. I can't figure out how to do this without entering the number manually. Thanks |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
link cells
Actually, I run into trouble every time I try to "multiply my Income by a
constant" also. I've tried =Income*WIFE, and =Income*GirlFriend, etc, but it always seems to come out as a BIG NEGATIVE NUMBER <BG. Seriously tho, David's suggestion will probably solve your problem, but if not, post your formula and we'll take a look. Vaya con Dios, Chuck, CABGx3 "Jim" wrote: That worked just fine, thanks. Now I want to take that figure and multiply it by a constant. I think I am not doing that correctly either because all it leaves in the cell is the formula "CLR" wrote: On the sheet where you want the total income, sheet put this formula, assuming the income is totaled in cell A1 of the Income sheet. =Income!A1 Vaya con Dios, Chuck, CABGx3 "Jim" wrote: I am doing a tax estimate workbook. It has 3 worksheets-income, deductions and tax calculation. I want to the income total from the income sheet in the deduction sheet. I can't figure out how to do this without entering the number manually. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
How do I link cells in 1 spreadsheet to Specific cells in another | Excel Discussion (Misc queries) | |||
PASTE LINK FROM HORIZONTAL CELLS TO VERTICAL CELLS | Excel Discussion (Misc queries) | |||
link cells | Excel Discussion (Misc queries) | |||
How do I link a row of cells in wks 1 to update diff cells wks 2 | Excel Worksheet Functions |