Results 1 to 3 of 3

Thread: Percetage formulas

  1. #1

    Percetage formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Can anyone help, what I have is a column with my buying costs in, next I have a column for GP% to put whatever is needed in, with the result next. IE 100 buying costs 20% GP result 125.00, what would a formula be please.

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    Perhaps something like:

    =A2*(1+B2)

    where A2 has buying cost and B2 has GP%.


  3. #3
    Thanks for that, but I'd already got that far, that's a mark-up %, the result should be say for 1000 + 20%GP 1250. For a mark up of 20% it would be 1200.
    Any ideas?

Posting Permissions

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