I thought I had sorted out my problem with this League ladder thanks to DonkeyOte, but trying it out I find in the Win, Loss, Draw columns when there is no entry the formula leaves a 1 when there should be a 0 in the Draw column.
I'm sure given time I might figure it out but I need this for this weekends matches, please someone help me.
I'm not sure if I needed to add this to my original post or start a new one, sorry If this is against forum policy.
Last edited by luk; 10-18-2009 at 09:30 AM.
Try this in J column:
=IF(OR(ISBLANK(C4);ISBLANK(D4));0;IF(C4=D4;1;0))
(replace ; with , if you get error)
or
H4: =(C4>D4)*ISNUMBER(C4)
I4: =(C4<D4)*ISNUMBER(C4)
J4: =(C4=D4)*ISNUMBER(C4)
copied down for remaining rows
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Always something to learn from your posts
When you writing a book?
Re: Win Loss Draw formula
Thankyou to both of you for your help. I did use Zbor's advice and all seems to work now. This forum has been a terrific help thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks