ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   changing cell values (https://www.excelbanter.com/excel-discussion-misc-queries/86420-changing-cell-values.html)

jamie&slings

changing cell values
 
At my place of employment I have made many spreadsheets that have prices of
materials in them. I know how to change the value of the cells by a percent,
but, I have one problem. When I want to change many rows and columns (most of
the cells) the outcome is very wrong from what I want. When I put the
percentage in a blank cell and highlight what I want to change, the new
numbers are way off from what I really want. But if I want just one row or
column changed the new numbers are right on. If I try to do them individually
the numbers in other cells change with each cell or row or column that I
change. I don't understand. Can anyone help? Thank you, Jamie

davesexcel

changing cell values
 

what is your formula,
how are you changing the values?


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=538218



All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com