+ Reply to Thread
Results 1 to 2 of 2

Question about If function

  1. #1
    Registered User
    Join Date
    08-22-2021
    Location
    Toronto
    MS-Off Ver
    Office 2019
    Posts
    1

    Question about If function

    Hello, and Nice to meet you.
    I am trying to do subtract calculation and I am kinda stock...
    I have attached my excel sheet so kindly refer.
    At Master Sheet F2, I am trying subtract/add number from C2 with both IN sheet and Out Sheet (Quantity In or Quantity Out)
    So my F2 (After Transaction Quantity calculation would be something like
    If (!IN, A2 field contains HotdogBox1), (!MasterC2 + !InD2)
    After Transaction Quality at Master sheet should be (100 + 20), 120

    If (!Out, A2 field contains HotdogBox2), (!MasterC2 + !OutD2)
    After Transaction Quality at Master sheet should be (100 - 20), 80.

    Hope I explained what i am trying to do.

    Kindly help me out!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,447

    Re: Question about If function

    Try this in F2:

    =C2+SUMIF(In!A:A,A2,In!D:D)-SUMIF(Out!A:A,A2,Out!D:D)

+ 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. User Defined function question. for a sigma function
    By thisisaMJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2018, 09:52 AM
  2. [SOLVED] Workbook_BeforeSave Question Function Question
    By thomasmc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-24-2015, 01:44 PM
  3. [SOLVED] IF function combined with another IF function question
    By Nexion21 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 05:13 PM
  4. IF function question
    By blue_izce8 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-11-2013, 06:47 AM
  5. IF Function Question:SUMIF function
    By VBA Noob in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-03-2007, 03:28 PM
  6. IF function question?, not sure
    By Tony Mach in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-24-2006, 03:54 PM
  7. Min. function question
    By mhb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-19-2005, 06:53 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