+ Reply to Thread
Results 1 to 2 of 2

Add defined value to cells

  1. #1
    Registered User
    Join Date
    09-01-2005
    Posts
    2

    Add defined value to cells

    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

  2. #2
    Forum Moderator dominicb's Avatar
    Join Date
    01-25-2005
    Location
    Lancashire, England
    MS-Off Ver
    MS Office 2000, 2003, 2007 & 2016 365
    Posts
    4,867

    Smile

    Good evening Paal

    Download and install my add-in via the link below.
    Highlight the range to apply the formula to and go to Ultimate > Formulae > Apply Formula(e) to Range.
    In the box type *VAT
    Click OK, and when asked if you want to convert to values select No.

    HTH

    DominicB
    Please familiarise yourself with the rules before posting. You can find them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1