SOLVED

IF statement

Copper Contributor

=IF(F4>G4,3,0)

I use this statement when

Cell   Cell

F4     G4     Answer

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 (Copper Contributor)
Solution

@Mikeman2022 

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

The Formula works perfectly. Thanks
=IF(F4>G4,3,0)

I use this statement when

Cell Cell

F4 G4 Answer

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

@Mikeman2022 

 

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

@Hans Vogelaar 

You are the Best!! Thanks

1 best response

Accepted Solutions
best response confirmed by Mikeman2022 (Copper Contributor)
Solution

@Mikeman2022 

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

View solution in original post