+ Reply to Thread
Results 1 to 2 of 2

Percentage Markup or Fixed Amount

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    Northern Ireland
    MS-Off Ver
    16.35
    Posts
    1

    Percentage Markup or Fixed Amount

    Im trying to create a grid formatted pricelist and i want to add either a percentage markup or a fixed amount whatever is greater

    What formula do i use?

  2. #2
    Valued Forum Contributor
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    455

    Re: Percentage Markup or Fixed Amount

    =MAX((1+pct mrkup)*value,value+fixed amount)
    If this isnt what you're looking forward, it would be better if you attached a sample file (please read the yellow banner at the top of this page.
    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

+ 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