+ Reply to Thread
Results 1 to 3 of 3

IF Formula to take name of company and compare amounts to return a difference in amounts

  1. #1
    Registered User
    Join Date
    04-24-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    17

    IF Formula to take name of company and compare amounts to return a difference in amounts

    I have 2 separate example spreadsheets on 2 different tabs. What formula can be used to take customer name from each tab and compare the amounts for the same company on each tab to return a difference if there is for both the Net amounts and gross amounts in columns D and E? Attached is a sample spreadsheet. Please let me know if I need to clarify what I am looking for.

    Thank you,
    Attached Files Attached Files

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,367

    Re: IF Formula to take name of company and compare amounts to return a difference in amoun

    Maybe like this?

    Cheers
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-24-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2010
    Posts
    17

    Re: IF Formula to take name of company and compare amounts to return a difference in amoun

    Solved thanks!
    Attached Files Attached Files
    Last edited by AAL; 02-23-2014 at 10:48 PM.

+ 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. [SOLVED] Add Invoice Amounts and Paid Amounts based on user inputs.
    By s2jrchoi in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-18-2013, 01:49 PM
  2. [SOLVED] Calculating amounts in a single currency from a list of multiple currency amounts
    By Romsky in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-03-2013, 12:22 PM
  3. Formula to take amounts from other sheet with no duplicate amounts
    By Xx7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-06-2013, 04:34 PM
  4. Sum the difference in amounts if items are in two tables
    By steinfm in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2012, 03:41 AM
  5. Replies: 1
    Last Post: 06-15-2010, 09:42 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