Remember Me?

Menu

#1
May 26th 06, 09:56 AM posted to microsoft.public.excel.misc
 wallisi Posts: n/a
need a formula which calculates points for a predictions league

we are running a predictions league for the world cup where for a correct
score you get 3 points and for a correct result you get 1 point. how can this
be done so there is the least amount of manual work?

#2
May 26th 06, 09:24 PM posted to microsoft.public.excel.misc
 mrice Posts: n/a
need a formula which calculates points for a predictions league

It sounds like you need to make use of the IF statement to do the
comparison

e.g = if (and(A1 = B1,A2 = B2),3,0)

for getting a correct score.

--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=545780

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 03:28 AM hw Excel Discussion (Misc queries) 2 May 26th 05 03:47 PM jbsand1001 Excel Worksheet Functions 1 January 5th 05 11:11 PM jbsand1001 Excel Worksheet Functions 0 January 5th 05 10:55 PM

All times are GMT +1. The time now is 09:15 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"

Copyright © 2017