+ Reply to Thread
Results 1 to 5 of 5

IF Statement combining multiple 'IF TRUE' conditions

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    92

    IF Statement combining multiple 'IF TRUE' conditions

    Assuming that I have a worksheet with columns A,B,C and D on it, I want an IF statement in column E which follows this argument:

    IF A1 is "0" or "N/A", then show N/A, but if A1 is any other number, then B*(C+D)

    I hope that's easy to follow. I have tried so hard to get this to work but just can't.

    As ever, any help would be hugely appreciated.

    Thank you

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: IF Statement combining multiple 'IF TRUE' conditions

    Maybe In E1 enter =IF(OR(A1=0, ISNA(A1)), NA(), B1*(C1+D1))

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    92

    Re: IF Statement combining multiple 'IF TRUE' conditions

    Thanks for this (and sorry for my slow reply, I wasn't able to log in yesterday).

    This formula sort of works, although it only works correctly if in A1 the value is '0'. If the value is "N/A" (which by the way is a pre-defined output, it could just as easily be 'duck' or 'chicken') in A1, then the output value in E1 is '#DIV/0!'

    Any ideas?

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.83 for Mac MS 365
    Posts
    8,480

    Re: IF Statement combining multiple 'IF TRUE' conditions

    try changing JieJen's formula of =IF(OR(A1=0, ISNA(A1)), NA(), B1*(C1+D1)) to this =IF(OR(A1=0,A1="N/A"),A1),B1*(C1+D1))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  5. #5
    Registered User
    Join Date
    02-09-2015
    Location
    London
    MS-Off Ver
    2013
    Posts
    92

    Re: IF Statement combining multiple 'IF TRUE' conditions

    Thanks, but that doesn't work at all. I get a 'the formula you typed contains an error' message

+ 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. Change from checking if 2 conditions are true to if any of 4 conditions are true
    By tafoyavision in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-26-2014, 02:17 PM
  2. Combining 3 conditions in IF statement
    By husni in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2014, 09:30 PM
  3. [SOLVED] Count occurences of a given value in Col A with multiple conditions being true
    By Howard Gale in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-17-2013, 11:26 AM
  4. COUNTIF - Multiple conditions are true
    By ryanw327 in forum Excel General
    Replies: 4
    Last Post: 11-24-2010, 08:32 PM
  5. Sum if multiple conditions (AND/OR) are true
    By Sameer123 in forum Excel General
    Replies: 2
    Last Post: 07-29-2010, 05:10 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