I have a spreadsheet with a table of prices and our prices have gone up. All I want to do is multiply 1.06 to every price in my table B5:Q31 and have result show on same table. Is this possible? Everything I have tried gives me error codes Err:509 or #value…
If I understand what you can, it is possible with paste special.
Put in a cell the value for multiply.
Copy the cell.
Select the range to multiply.
Menu/Paste special/Operations - Multiply.
THAT WORKED AND NOW I CAN UPDATE THIS SO MUCH FASTER!
THANK YOU FOR MAKING MY DAY!!!
@jr09645 Could you mark the answer as correct by clicking the checkmark?