Results 1 to 4 of 4

Help with Cell formulas please

Threaded View

danumdave Help with Cell formulas please 09-28-2011, 06:09 AM
Bob Phillips Re: Help with spreadsheet... 09-28-2011, 06:24 AM
danumdave Re: Help with spreadsheet... 09-28-2011, 10:49 AM
Bob Phillips Re: Help with spreadsheet... 09-28-2011, 01:09 PM
  1. #1
    Registered User
    Join Date
    09-28-2011
    Location
    Doncaster
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help with Cell formulas please

    Hello,

    I wondered if anybody could help please?

    I use Excel 2003 and run a football predictions competition amongst friends each year

    I wondered whether I could adapt my excel table to work out my rather complex points scoring system

    I feel fairly confident that if I got started I would be OK

    Basically if you correctly predict the outcome of a match, you score 10 points
    years ago in BASIC that would have been something like
    IF (a1=b1) THEN LET c1=c1+10

    Where a = prediction b=Result and c= Points Tally for player

    I looked at the help in MS and to be frank Im flumoxxed

    I forgot to add the scores are entered as 2-1 where 2-1 the cell is formatted as Text

    Thanks in advance
    Last edited by danumdave; 09-28-2011 at 10:44 AM. Reason: forgot something

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