Feb 02 2024 09:31 AM
Feb 02 2024 09:52 AM
To make the change in the existing columns, you must first calculate the change elsewhere, then paste it over the original data.
This formula (adjusted for the corrected number of rows in your spreadsheet):
Calculates the new values:
I've put the formula below the original data to make the image size more sensible, but you can put the formula wherever you want.
You can then copy and paste values to replace the original values. Or not, if you prefer.