Results 1 to 7 of 7

If formulae with multiple conditions

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    If formulae with multiple conditions

    I guys i have this formulae to sum cell Q34 and Q35 of sheet "INVOICE"

    The formulae is
    =IF(Q35>0,Q34+Q35,"")
    I need to sum cell Q34 & Q35 if it meets certain criteria
    i.e:

    1) if q35>0
    2) if either p38,p39 or q40>0

    I am able to integrate the first criteria.
    However I am unable to integrate the second criteria


    Can anyone please help me?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code to replace formulae in cells and then re-enter same formulae again after run
    By excel_msa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2017, 06:56 AM
  2. needs help for multiple ifs and or formulae
    By Shermin in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-05-2017, 03:55 AM
  3. Replies: 2
    Last Post: 01-14-2016, 03:53 PM
  4. Help with three specific formulae to match and count several conditions
    By Satele in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2014, 12:18 AM
  5. [SOLVED] Vlookup - Country conditions (Multiple conditions)
    By dluhut in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-26-2013, 11:42 AM
  6. Replies: 10
    Last Post: 04-18-2012, 07:30 AM
  7. [SOLVED] how to use a IF(AND) formulae for more than seven conditions
    By Mohit in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-12-2006, 09:00 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