+ Reply to Thread
Results 1 to 2 of 2

sum and if combination in a formula

Hybrid View

  1. #1
    Registered User
    Join Date
    01-26-2007
    Posts
    2

    sum and if combination in a formula

    Hello all, I have three columns of data, each column will have a value of either zero or one

    Column 1 Column 2 Column 3
    1 0 1

    In Column 4, I would like to have a simple formula that sums up the values in columns 1-3; if that value is greater than 2 I would like Column 4 to display the value yes, otherwise, I would like column 4 to display the value "no"
    Any help?
    Yours,
    Simon Kiss

  2. #2
    Forum Contributor
    Join Date
    04-23-2009
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003 work, 2007 home
    Posts
    199

    Re: sum and if combination in a formula

    this should do it , put formula in D1 assuming data is in columns A:C
    =IF(SUM(A1:C1)>2,"yes","no")
    Last edited by somesoldiers; 07-21-2009 at 02:39 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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