How to divide/multiply a cell value without leaving the cell

So, part of the problem is adequately describing what I want in a sentence. I wasn't able to find anything like it in my search.


What I want is a short-hand for the following:


I want to change the value of a cell by the product/quotient (or any other operator) of an integer (or decimal). I have a range of cells with numerical values. Each has more than two decimal places and I want to capture all of the decimals in the conversion. In this case, I want to divide each cell in the range by 2, replacing each cell with this result.


How I know to do it is to create a new column with a formula that references the original and divides it by 2. (B1 = 12.5. New cell C1 set to = B1 /2 (=6.25)). Then, I copy the new cell, C1, and paste the formula results back into the original, B1.


I feel like there is (should be) a shorthand for this where I can just change the value in a cell by an operator and a constant without having to exit the cell and save some steps. Any chance?? Thank you

MacBook Pro 16″, macOS 14.4

Posted on Apr 15, 2024 12:28 PM

Reply
Question marked as Best reply

Posted on Apr 15, 2024 6:50 PM

There is no built-in feature to do it but there is a "shortcut" for it.


Im trying to convert data from MS Access … - Apple Community


1 reply

How to divide/multiply a cell value without leaving the cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.