+ Reply to Thread
Results 1 to 6 of 6

Price comparison (+ or -) formula

  1. #1
    Forum Contributor
    Join Date
    04-04-2016
    Location
    chicago
    MS-Off Ver
    2013
    Posts
    100

    Price comparison (+ or -) formula

    I am looking for some help to develop a calculation to evaluate cost for products and cores
    Column A MSRP and B CORE are the main data sources. I need Column A MSRP and B CORE compare them to C MSRP and D CORE and display the difference in column E and F.
    Column A MSRP and B CORE are the main data sources. I need Column A MSRP and B CORE compared to them to G MSRP and H CORE and display the difference in column I and J
    This goes through out
    For example when comparing Column A MSRP and B CORE with column C MSRP and D CORE I like to know which one is higher and which one is lower in price.


    Sample file attached
    Attached Files Attached Files

  2. #2
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Price comparison (+ or -) formula

    -----deleted------
    Last edited by dosydos; 09-20-2016 at 04:38 PM.

  3. #3
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Price comparison (+ or -) formula

    This seems a little easy, which makes me feel like i am not understanding correctly but are you just asking for:
    column E =A-C
    Column F =B-D
    column I =A-G
    column J =B-H

  4. #4
    Forum Contributor
    Join Date
    04-04-2016
    Location
    chicago
    MS-Off Ver
    2013
    Posts
    100

    Re: Price comparison (+ or -) formula

    No you are correct however is there a way to make a different color . For example on A-C if A is more $$ make it a unique color if its less $$make it a different color.

  5. #5
    Forum Expert dosydos's Avatar
    Join Date
    12-09-2015
    Location
    Massachusetts
    MS-Off Ver
    365(PC) V:2308
    Posts
    1,472

    Re: Price comparison (+ or -) formula

    Yes there is, you are going to want to utilize the conditional Formatting on the Home Ribbon.

    or you can change the formatting of negative numbers as if C>A it will be a negative difference.

  6. #6
    Forum Contributor
    Join Date
    04-04-2016
    Location
    chicago
    MS-Off Ver
    2013
    Posts
    100

    Re: Price comparison (+ or -) formula

    Thanks for your help

+ 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. Multiple Vendor Price Comparison Sheet
    By psasp in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 04-19-2015, 05:15 AM
  2. Competitors Price Comparison Other Methods they May Use
    By ryanb4614 in forum Excel General
    Replies: 3
    Last Post: 04-16-2015, 07:47 PM
  3. How to automate weekly price updates from diff. suppliers into 1 price comparison sheet
    By blindside21 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-09-2014, 02:24 PM
  4. Help with Price comparison / percentage change...
    By Crispyglock in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-15-2012, 11:19 AM
  5. [SOLVED] Grocery List with Price comparison
    By mrJack808 in forum Excel General
    Replies: 8
    Last Post: 04-04-2012, 10:57 AM
  6. Replies: 5
    Last Post: 08-16-2009, 11:11 AM
  7. Price Comparison Macro - This Is For An Excel MVP
    By Mr. Smiley in forum Excel General
    Replies: 5
    Last Post: 08-30-2005, 01:05 PM

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