+ Reply to Thread
Results 1 to 3 of 3

help! compare my price with a competitors price by a percentage

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    California
    MS-Off Ver
    2013
    Posts
    2

    help! compare my price with a competitors price by a percentage

    Hello,

    (A) competitors price (B) my price (C) fancy formula
    1} $11.00 $7.94 $11.00
    2} $3.70 $3.77 $4.90
    3} $45.92 $44.70 $58.11
    4} $11.15 $8.52 $11.15

    I would like the formula to return a price that will match my price to the (A) "competitor" if the price is higher than 30% if not take (B) "my price" and mark it up by 30% (C) fancy formula

    on row 1} (A) "competitor" price is $11.00 and (B) "my price" is $7.94 I would like to to return their price in this case. On row 2} the competitors price is lower than my price but I need to make a profit still so I would like to formula to mark up my price by 30%

    On row 3} the competitors price is very close to my price but higher than my price so I can't have it mach because I do not get the 30% minimum mark up.

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,463

    Re: help! compare my price with a competitors price by a percentage

    Try

    =MAX(A1,B1*1.3)
    Quang PT

  3. #3
    Registered User
    Join Date
    01-08-2019
    Location
    California
    MS-Off Ver
    2013
    Posts
    2

    Re: help! compare my price with a competitors price by a percentage

    I was trying to use if and statements making it too complicated. Thank you so much!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 08-06-2018, 05:39 AM
  2. Expressing Selling Price as a percentage of List Price
    By Antman452 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-02-2016, 08:21 AM
  3. Competitors Price Comparison Other Methods they May Use
    By ryanb4614 in forum Excel General
    Replies: 3
    Last Post: 04-16-2015, 07:47 PM
  4. calculate price between max and min price using percentage number
    By pzouboul in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 05:59 PM
  5. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  6. [SOLVED] Compare 1 price against multiple prices and change the price according to a formula
    By CharlieAziz in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-16-2012, 11:05 AM
  7. Replies: 4
    Last Post: 08-15-2012, 09:49 AM

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