I would like to change a whole bunch of cells, in a 64 x 11 rectangle. The values in each cell are dollar amounts, and I would like to increase each of these values by 5%. That is, if a dollar amount is $1325.00, and increase in 5% would have it equal $1391.25. Is there a fast way to do this?
problem for MS Excel
- Thread starter wally222
- Start date
sweetcheeks69
New Member
I am sure there is a tidier way to do this, but this will work:
First cell (for arguments sake, A1): $1325.00
Second (and subsequent cells), copy this into the first one (ie, B1): "= A1*1.05"
If you use the node in the bottom-right corner of cell B1 (after pasting) and drag that into your required area, this should work...
Let me know if this gives you the required result...
First cell (for arguments sake, A1): $1325.00
Second (and subsequent cells), copy this into the first one (ie, B1): "= A1*1.05"
If you use the node in the bottom-right corner of cell B1 (after pasting) and drag that into your required area, this should work...
Let me know if this gives you the required result...