Formula Problem.

[rusty21]

Good Morning All,

I am trying to format a sheet I have for the football team I run.

I have a score sheet and want to automatically pull data from it using W,L D (Win, Loss, Draw) this data is in E21, so that I can automatically make a table showing the results. I have used the formula below:

=IF(E19>E20,"W",IF(E19<E20,"L",IF(E19=E20,"D",)))

The problem I have is that the cells that have not been filled in (as we have not played the games) are showing a D and skewing the data.

How can I write into this that if the cell is blank to leave E21 blank (or enter an X) if there is no data entered?

Thank you in advance.
Rusty

 

[rusty21]

Sorry it did not copy whole formula not sure how to do it. As it will not copy the whole thing. Reply<e20,"l",if(e19=e20,"d",)))< html=""></e20,"l",if(e19=e20,"d",)))<>

 

[Aladin Akyurek]

You need to place spaces around the < symbol to post your full formula.

 

[RicoS]

Hi,

Something like this?

<=IF(OR(E19="",E20=""),"",IF(E19>E20,"W",IF(E19=E20,"D",IF(E19<E20,"L"))))>

 

[RicoS]

Hi,

Something like this?

=IF(OR(E19="",E20=""),"",IF(E19>E20,"W",IF(E19=E20,"D",IF(E19<e20,"l"))))>

Oops, I just made the same mistake as you!
</e20,"l"))))>
=IF(OR(E19="",E20=""),"",IF(E19 > E20,"W",IF(E19=E20,"D",IF(E19 < E20,"L"))))

 

[rusty21]

oops, i just made the same mistake as you!

=if(or(e19="",e20=""),"",if(e19 > e20,"w",if(e19=e20,"d",if(e19 < e20,"l"))))

=if(e19">"e20,"w",if(e19"<"e20,"l",if(e19=e20,"d",)))

 

[Aladin Akyurek]

=if(e19">"e20,"w",if(e19"<"e20,"l",if(e19=e20,"d",)))

=IF(E19 > E20, "w", IF(E9 < E20, "l", IF(E19 = E20, "d",)))

This is apparently your formula...

Something like this:

=IF(COUNT(E19:E20)=2, IF(E19 > E20, "w", IF(E19 < E20, "l", "d")), "")

seems to be on your mind.

 

[rusty21]

That,s, got it. Thank you so much

Regards
Rusty

 

[Aladin Akyurek]

That,s, got it. Thank you so much

Regards
Rusty

You are welcome.