+ Reply to Thread
Results 1 to 4 of 4

it worked adapted formula now doesn't please help

Hybrid View

  1. #1
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,312

    Re: it worked adapted formula now doesn't please help

    Hi worthingto and welcome to the forum,
    Change the first formula to:
    =IF((D4+C4)>(L4+M4),1, IF((D4+C4)=(L4+M4), .5,0))
    then make the second formula
    =Sum(D16:D20)
    The idea here is instead of making a Win = True, you will make it a 1. Also a tie will be = .5.

    I hope this makes sense and helps. If not you need to attach your workbook so we can see what is happening. You can do that by clicking on "Go Advanced" and then the Paper Clip Icon above the advanced message area.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  2. #2
    Registered User
    Join Date
    09-18-2011
    Location
    Shippensburg, PA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: it worked adapted formula now doesn't please help

    you are AWESOME!!! i knew it was something so simple yet so FRUSTRATING

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1