SOLVED

IF statement

%3CLINGO-SUB%20id%3D%22lingo-sub-3302492%22%20slang%3D%22en-US%22%3EIF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302492%22%20slang%3D%22en-US%22%3E%3CP%3E%3DIF(F4%26gt%3BG4%2C3%2C0)%3C%2FP%3E%3CP%3EI%20use%20this%20statement%20when%3C%2FP%3E%3CP%3ECell%26nbsp%3B%20%26nbsp%3BCell%3C%2FP%3E%3CP%3EF4%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BG4%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BAnswer%3C%2FP%3E%3CP%3E12%26nbsp%3B%20%26nbsp%3B%2011%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B3%3C%2FP%3E%3CP%3E10%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B13%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%200%3C%2FP%3E%3CP%3EI%20need%20to%20rewrite%20the%20Statement%20so%20that%20it%20also%20includes%20tie%20numbers%3C%2FP%3E%3CP%3Eso%20if%20the%20scores%20are%20tie%20the%20answer%20will%20be%201%2C%3C%2FP%3E%3CP%3E12%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B12%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B1%3C%2FP%3E%3CP%3Eany%20assistance%20would%20be%20appreciated.%20tx%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3302492%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302508%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302508%22%20slang%3D%22en-US%22%3EThe%20Formula%20works%20perfectly.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3302499%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3302499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1380904%22%20target%3D%22_blank%22%3E%40Mikeman2022%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(F4%26gt%3BG4%2C3%2CIF(F4%3DG4%2C1%2C0))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3310356%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3310356%22%20slang%3D%22en-US%22%3E%3DIF(F4%26gt%3BG4%2C3%2C0)%3CBR%20%2F%3E%3CBR%20%2F%3EI%20use%20this%20statement%20when%3CBR%20%2F%3E%3CBR%20%2F%3ECell%20Cell%3CBR%20%2F%3E%3CBR%20%2F%3EF4%20G4%20Answer%3CBR%20%2F%3E%3CBR%20%2F%3E12%2011%203%3CBR%20%2F%3E%3CBR%20%2F%3E10%2013%200%3CBR%20%2F%3EI%20need%20to%20rewrite%20the%20Statement%20so%20that%20it%20also%20includes%20tie%20numbers%3CBR%20%2F%3Eso%20if%20the%20scores%20are%20tie%20the%20answer%20will%20be%201%2C%3CBR%20%2F%3E12%2012%201%3CBR%20%2F%3EProblem%3A%20Formula%20sees%20BLANK%20cells%20as%20equal%20and%20formula%3CBR%20%2F%3Ereturns%20a%20value%20of%201%20(this%20messes%20up%20Column%20Totals).%3CBR%20%2F%3EI%20need%20the%20BLANK%20cell%20in%20F7%20G7%20to%20show%20a%20ZERO.%3CBR%20%2F%3ESorry%2C%20I%20didn't%20realize%20this%20earlier.%3CBR%20%2F%3Eany%20assistance%20would%20be%20appreciated.%20tx%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3312577%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3312577%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1380904%22%20target%3D%22_blank%22%3E%40Mikeman2022%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(OR(F4%3D%22%22%2CG4%3D%22%22)%2C0%2CIF(F4%26gt%3BG4%2C3%2CIF(F4%3DG4%2C1%2C0)))%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3319628%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20statement%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3319628%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20the%20Best!!%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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 (New 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