+ Reply to Thread
Results 1 to 2 of 2

percentages

  1. #1
    Registered User
    Join Date
    09-03-2007
    Posts
    1

    percentages

    hi guys and gals i have a bit of a problem, what i need to do is:

    times 450 (I5) by 10% (H5)

    then dicount it by 10% (I12)
    then add VAT off 17.5% (I13)

    ive been trying for a few hours now and looking on the forums its all to mind boggiling for me any help would be greatly appreciated.

    W.Holloway

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Hello W,

    Taking the above literally, if you take 10% of 450 you get 45, if you then discount this by 10% (deduct 10%) you get 40.5 and if you then add 17.5% you get 47.5875.

    Is that the answer you expect? If so the formula is

    =I5*H5*(1-I12)*(1+I13)

+ 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