I have defined a value in my spreadsheet (VAT=1.2), using Insert > Name > Define. I want to add this value to several cells, e.g A1:A5. These cells contain different numbers, let's say 10, 20, 30, 40, 50. Is there a way to multiply these cells by VAT (1.2) at the same time? The cells should look like (10*VAT), (20*VAT), (n*VAT). I know I can use Paste Special > Multiply, but then the original value will disappear.
Thanks,
BR Paal
Bookmarks