SOLVED

New Contributor

# IF statement

=IF(F4>G4,3,0)

I use this statement when

Cell   Cell

12    11       3

10     13      0

I need to rewrite the Statement so that it also includes tie numbers

so if the scores are tie the answer will be 1,

12     12       1

any assistance would be appreciated. tx

5 Replies
best response confirmed by Mikeman2022 (New Contributor)
Solution

# Re: IF statement

=IF(F4>G4,3,IF(F4=G4,1,0))

# Re: IF statement

The Formula works perfectly. Thanks

# Re: IF statement

=IF(F4>G4,3,0)

I use this statement when

Cell Cell

12 11 3

10 13 0
I need to rewrite the Statement so that it also includes tie numbers
so if the scores are tie the answer will be 1,
12 12 1
Problem: Formula sees BLANK cells as equal and formula
returns a value of 1 (this messes up Column Totals).
I need the BLANK cell in F7 G7 to show a ZERO.
Sorry, I didn't realize this earlier.
any assistance would be appreciated. tx

# Re: IF statement

=IF(OR(F4="",G4=""),0,IF(F4>G4,3,IF(F4=G4,1,0)))

# Re: IF statement

You are the Best!! Thanks