+ Reply to Thread
Results 1 to 8 of 8

Mixing 2 Formulas Together

  1. 09-04-2017, 11:24 AM #1
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Mixing 2 Formulas Together

    Hi, can I ask for a quick suggestion. How do we mix these two formulas together?

    =IF(E28="","-",(E28+INDEX('All Accs'!D:D,MATCH("Japan",'All Accs'!A:A,0))))

    =IF(E28="","-",(E28+INDEX('All Accs'!D:D,MATCH("UK",'All Accs'!A:A,0))))

    Please note, the difference is 'Japan' and 'UK'.

    The issue - while one formula works well for 1 criteria (Japan), I find it difficult to include a 2nd criteria to it (UK)

    EDITED: too, when it says Japan, we +add values. When it says UK, we -deduct values.

    How do we do that?, please?

    Thanking you!!
    Reply With QuoteRegister To Reply
  2. 09-04-2017, 12:15 PM #2
    Glenn Kennedy
    Glenn Kennedy is offline
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,053

    Re: Mixing 2 Formulas Together

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
    Reply With QuoteRegister To Reply
  3. 09-04-2017, 01:31 PM #3
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Mixing 2 Formulas Together

    Great guides, was not aware. Here is Excel attached. Hope it's okay:

    https://www.excelforum.com/attachmen...1&d=1504546237
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-04-2017, 01:47 PM #4
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Mixing 2 Formulas Together

    The simplest way to do this would be to leave the formula as it is and change the value in I6 from 100 to -100.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
  5. 09-04-2017, 01:47 PM #5
    oeldere
    oeldere is offline
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Mixing 2 Formulas Together

    with Vlookup.

    see the attached file.
    Attached Files Attached Files
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.
    Reply With QuoteRegister To Reply
  6. 09-04-2017, 04:14 PM #6
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Mixing 2 Formulas Together

    Received, helpful, thank you! !!
    Reply With QuoteRegister To Reply
  7. 09-04-2017, 04:19 PM #7
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Mixing 2 Formulas Together

    You're welcome, glad we could help.

    If that takes care of your original question, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig). Thanks.
    Reply With QuoteRegister To Reply
  8. 09-04-2017, 04:30 PM #8
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: Mixing 2 Formulas Together 

    Please Login or Register  to view this content.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mixing Formulas
    By LuisJoel in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-04-2015, 10:00 AM
  2. [SOLVED] Mixing two formulas.
    By boboivan in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-05-2014, 12:14 PM
  3. Mixing Formulas
    By nikkie456 in forum Excel General
    Replies: 1
    Last Post: 09-12-2013, 10:54 AM
  4. Mixing AVERAGEIF() with OR() & AND()
    By gdel in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2013, 09:39 AM
  5. Mixing Excel Formulas/Functions with VBA
    By garithmar in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-23-2013, 03:26 PM
  6. mixing up numbers
    By aquinlan in forum Excel General
    Replies: 0
    Last Post: 10-13-2011, 01:20 PM
  7. Mixing Formulas with Validation
    By dandavis1 in forum Excel General
    Replies: 1
    Last Post: 05-05-2009, 05:55 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1