This works except when both cells are blank.

  • Thread starter Thread starter StargateFan
  • Start date Start date
S

StargateFan

Every once in a blue moon I get to work on a personal project. This
is for track of some scores. I modified the formula from some code in
the ng archives but haven't figured out how to take care of when both
cells are blank.

In E2:
=IF($C2>$D2,"YOU WON!!",IF($C2<$D2,"You Lost ... :o(","Tied!"))

this works great unless both C2 and D2 are blank when I get "Tied!"
whereas should be blank. How do we accommodate for blank cells in the
above formula?

Thanks! :oD
 
=if(count($c2:$d2)<2,"not enough scores", ...

You could use =counta() instead if you can type strings in those cells.
 
Try this.
=IF(AND(ISNUMBER(C2),ISNUMBER(D2)),IF(C2=D2,"tied",IF(C2>D2,"Won","lost")),"")
 
Try this.
=IF(AND(ISNUMBER(C2),ISNUMBER(D2)),IF(C2=D2,"tied",IF(C2>D2,"Won","lost")),"")
Click to expand...

Thanks, this seem to be working perfectly!
'course, I had to add all the 'emotion' back in to the text strings
<g>:

=IF(AND(ISNUMBER($C2),ISNUMBER($D2)),IF($C2=D2,"Tied!",IF($C2>$D2,"YOU
WON!","You lost :o(")),"")

Thanks! :oD
 
Back
Top