Help needed with numbers formula

Discussion in 'Mac Apps and Mac App Store' started by paulsalter, Jan 18, 2009.

  1. paulsalter macrumors 68000

    paulsalter

    Joined:
    Aug 10, 2008
    Location:
    UK
    #1
    I am sure this is an easy one (dont often use spreadsheets) but cannot figure this out

    I am trying to do a sporting spreadsheet and based upon scores automatically fill in the names for the next round

    The spreadsheet is fairly simple
    Name A, Name A Score, Name B, Name B Score (A1,B1,C1,D1)

    From this I want the winner (first to 6) to be automatically added into next round, so in the next round box I have

    =IF(B1=6,A1,C1)

    Which works correctly but I do not want to do this if the result is blank, or ideally only do this if one of the results is 6 (without a score it puts Name B as winner)

    Like this, but I cant figure out how to do this as a formula
    If B1=6 then fill this box with A1, If D1=6 the fill this box with C1

    Thanks for any help
     
  2. reclusivemonkey macrumors 6502

    reclusivemonkey

    Joined:
    Jun 2, 2008
    Location:
    Sowerby Bridge, West Yorkshire, UK
    #2
    You can add a second IF statement to do this.

    Code:
    =IF(C3>=6,B3,IF(E3>=6,D3,""))
     
  3. paulsalter thread starter macrumors 68000

    paulsalter

    Joined:
    Aug 10, 2008
    Location:
    UK
    #3
    Thanks
     

Share This Page