Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a column of 81 cells all containing different salaries. I need to add
3.5% to all of these cells to show annual raises without doing every cell inidvidually. Please advise. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
in an empty cell type 3.5% then copy, special paste--select value & add--
select ok hope it works "JB" wrote: I have a column of 81 cells all containing different salaries. I need to add 3.5% to all of these cells to show annual raises without doing every cell inidvidually. Please advise. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try this:
Enter 1.035 into any blank cell Copy that cell Select your range of 81 cells Paste Special Check the "Multiply" option Click OK Delete the 1.035 you entered originally HTH, Elkar "JB" wrote: I have a column of 81 cells all containing different salaries. I need to add 3.5% to all of these cells to show annual raises without doing every cell inidvidually. Please advise. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
sorry I relized your salary column probably is in $$ so you can type 1.035 in
a cell and copy --paste special select value & multiply so if you have 1000 you will have 1035. now you will have "JB" wrote: I have a column of 81 cells all containing different salaries. I need to add 3.5% to all of these cells to show annual raises without doing every cell inidvidually. Please advise. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() Say your column of salaries are A1-A80 in B1 enter the formula (C5*0.035)+C5. Copy it and paste it to B2-B80. Done. -- DRANDON ------------------------------------------------------------------------ DRANDON's Profile: http://www.excelforum.com/member.php...o&userid=35901 View this thread: http://www.excelforum.com/showthread...hreadid=566083 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
how do i number cells in a column from 1-506 in excel | New Users to Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Check COlumn - Excel VBA | Excel Discussion (Misc queries) |