DECREASE CELL VALUES BY 50%

  • Thread starter Thread starter Sandra Dryden
  • Start date Start date
S

Sandra Dryden

I have either entered data and performed calculations on the amounts entered
in most cells in my workbook to come up with a budget for the year. I want
to decrease the total by say $100,000 and see what the data entry figures
would need to be to come up with the revised total.
 
--Enter 2 in a unused cell and copy the cell
--keeping the copy Select the data range (values which are to be converted)
--Right click>PasteSpecial>select Divide>OK

If this post helps click Yes
 
OMG --- too easy. Thanks so much

Jacob Skaria said:
--Enter 2 in a unused cell and copy the cell
--keeping the copy Select the data range (values which are to be converted)
--Right click>PasteSpecial>select Divide>OK

If this post helps click Yes
Click to expand...
 
Back
Top