+ Reply to Thread
Results 1 to 3 of 3

If then, if then, else do nothing?

  1. 10-03-2015, 07:10 AM #1
    realrookie
    realrookie is offline
    Forum Contributor
    Join Date
    07-14-2012
    Location
    Belgium/UK
    MS-Off Ver
    Excel 2003
    Posts
    111

    If then, if then, else do nothing?

    Hello,

    Looking for a if then formula please.

    IF A1=1 then B1+C1 but if A1=0 then B1+D1, but if A1=Blank then dont sum anything?

    RR
    Reply With QuoteRegister To Reply
  2. 10-03-2015, 07:14 AM #2
    Tony Valko
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: If then, if then, else do nothing?

    Try this...

    =IF(A1="","",IF(A1=1,B1+C1,IF(A1=0,B1+D1,"")))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
  3. 10-03-2015, 07:14 AM #3
    samba_ravi
    samba_ravi is online now
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: If then, if then, else do nothing?

    =if(a1="","",if(a1=0,b1+d1,if(a1=1,b1+c1,"")))
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1