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