+ Reply to Thread
Results 1 to 4 of 4

How to create one formula providing a result based on specific criteria

  1. #1
    Registered User
    Join Date
    10-24-2016
    Location
    Los Angeles, California
    MS-Off Ver
    MS Office 2016
    Posts
    5

    Question How to create one formula providing a result based on specific criteria

    Hi,

    I need assistance obtaining one formula providing a result in column D on my attached example based on the following criterias:

    If a "Var" (column B) is present then the sum of "Var" & "Sep 1QFC" (column B & C) is the "Result" (column D)
    If a "Var" (column B) is not present then the sum of "PRB Forecast" & "Sep 1QFC" (column A & C) is the "Result" (column D)
    If there are zero values then result shows a "-" in the cell

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,999

    Re: How to create one formula providing a result based on specific criteria

    =if(b2<>"",b2+c2,if(b2="",if(a2+c2=0,"-",a2+c2)))
    Attached Files Attached Files
    Last edited by etaf; 09-16-2020 at 05:49 PM.
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Registered User
    Join Date
    10-24-2016
    Location
    Los Angeles, California
    MS-Off Ver
    MS Office 2016
    Posts
    5

    Re: How to create one formula providing a result based on specific criteria

    Thank you for your assistance. The formula worked as expected.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX, 365 for windows, Windows 10 Insider
    Posts
    5,999

    Re: How to create one formula providing a result based on specific criteria

    you are welcome

+ 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. If Statement is providing wrong result
    By EAlden01 in forum Excel General
    Replies: 5
    Last Post: 02-05-2019, 02:21 AM
  2. VBA to create MsgBox based on Formula result
    By carriey in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2015, 10:26 AM
  3. Vlooking up in Min and Max values and providing the result
    By wasiali in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2015, 10:33 AM
  4. [SOLVED] Create unique list based on specific criteria
    By Joynesy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-21-2013, 05:54 AM
  5. An IF formula result that based on multiple criteria
    By johnfash in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-15-2013, 08:15 AM
  6. Urgent: Create a Dynamic Dropdown list based on a specific criteria
    By vijaye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2013, 08:07 AM
  7. create a dynamic drop down list based on specific criteria
    By stevegrobertson in forum Excel General
    Replies: 4
    Last Post: 02-21-2012, 08:07 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