+ Reply to Thread
Results 1 to 2 of 2

How to include exceptions and conditions in your formula such as IF/THEN, AND/OR, etc

  1. #1
    Registered User
    Join Date
    10-09-2017
    Location
    Santa Barbara, CA
    MS-Off Ver
    Office 365
    Posts
    1

    How to include exceptions and conditions in your formula such as IF/THEN, AND/OR, etc

    I have a large range of data, and I need the cells in one column to calculate the sum of several cells UNLESS another paticular cell has a value greater than 0, then the value in that the corresponding cell in that column should equal that cell.

    For example:

    Q2 = A2+B2+C2+D2 UNLESS E2>0 THEN Q2 = E2

    Does anyone what formula I need to do this?

    Thanks!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 365
    Posts
    20,183

    Re: How to include exceptions and conditions in your formula such as IF/THEN, AND/OR, etc

    In Q2 type =if(E2>0,E2, A2+B2+C2+D2)

    To understand this, =if(criteria, answer if true, answer if false)

+ 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] IF formula with AND conditions that include omitting named formulas
    By frsaxon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-16-2017, 01:02 AM
  2. [SOLVED] IF formula to include multiple conditions
    By BOECKENJ in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 06-07-2015, 03:49 AM
  3. [SOLVED] IF formula to include multiple conditions
    By sunshine82 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-04-2015, 09:16 AM
  4. Replies: 17
    Last Post: 08-26-2014, 01:05 PM
  5. IF(OR Formula will not include certain conditions
    By Holly.Pittam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2014, 05:53 AM
  6. Replies: 1
    Last Post: 11-09-2011, 04:45 AM
  7. SUMIF to include several conditions?
    By tangcla in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-28-2008, 08:39 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1