Results 1 to 12 of 12

If and statement for multiple criteria

Threaded View

  1. #11
    Valued Forum Contributor
    Join Date
    12-28-2014
    Location
    NSW, Australia
    MS-Off Ver
    MS365
    Posts
    606

    Re: If and statement for multiple criteria

    ahh, you are absolutely right....sorry about that.
    I'm glad you have it fixed, but incase you did want the correct formula:-

    =IF(C75="YES",MIN(COUNTIF(K14:M14,">"&0)*60,150),0)
    Edit:- BTW, that formula leaves 0 in the cell if C75 is NOT "YES". If you would rather the cell be blank:-
    =IF(C75="YES",MIN(COUNTIF(K14:M14,">"&0)*60,150),"")
    Last edited by Beamernsw; 01-04-2016 at 11:46 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If Statement with Multiple Criteria
    By jdoerr1021 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-21-2015, 11:04 AM
  2. [SOLVED] countifs statement with multiple criteria for multiple criteria ranges
    By mcdermott2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-07-2015, 11:48 AM
  3. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  4. [SOLVED] If statement that will look among multiple criteria and generate a statement
    By liz5818 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2013, 04:12 PM
  5. [SOLVED] Multiple Criteria within an If Statement.
    By UsmanBPD in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-24-2012, 12:52 PM
  6. If statement with multiple criteria
    By Savitri in forum Excel General
    Replies: 2
    Last Post: 06-06-2010, 11:25 PM
  7. If Statement with multiple criteria
    By Ada01 in forum Excel General
    Replies: 4
    Last Post: 11-19-2009, 10:26 AM

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