Microsoft excel...Help required - The Punters Lounge

El_Stuart · 05-09-2006, 20:31

Ok, heres the deal. I have an excel document that contains 7 rows of data i insert...I then have a series of IF sums that convert whatever i put into them to another figure (like doing ratings for something). Anyway it took me about 6 hours to get all that lot working but i still have a problem...

...I have another cell that i want to total up everything in the cells with the IF formula's in but it always shows the sum as 0 for some reason. Its as if the sheet isnt reading the cells as containing numbers, but they do...

Anyone offer any help?

PAULM03 · 05-09-2006, 20:36

Can you post an example?

El_Stuart · 05-09-2006, 20:42

OK, say i have 10 cells across the top, In these i insert how many goals a team scored in there last 10 games. The next 10 cells are calculated via IF calculations to translate these for me, say if its a 1 to assign 10 points to a corresponding cell and so on.....I want then to be able to have a final cell that calculates the new figures from the calculated cells but it wont have it.

Id actually post an example here if i knew how

GotaFancy?(BPP) · 05-09-2006, 20:47

Have you put the 10 points in the IF statement in quotes?

It should be:

If(A2=1,10,0)

not

If(A2=1,"10",0)

Think that MAY be one possible explanation.....

To put the example up, should be able to just copy and paste (in IE, not Firefox)

El_Stuart · 05-09-2006, 20:52

Ugh, I guess il hafta bust out IE (something i NEVER like doing).

All the if calculations work ok, they are all sorted and i get a line of 10 new figures from the original data i enter and all is well....then when i set a cell to SUM all these new figures, it just always shows as 0...

..UGH, I HATE TECHNOLOGY!!!

GotaFancy?(BPP) · 05-09-2006, 20:56

Can you copy and paste one of your formulas? You can do it in firefox

El_Stuart · 05-09-2006, 21:01

Ok i have formulas in cells L2 to Q2 that are calculated......

=IF(G2=0,"0",IF(G2<=3,"7",IF(G2=4,"13",IF(G2=5,"11",IF(G2=6,"8",IF(G2=7,"3",IF(G2>=8,"1","0")))))))

Now that gets the results i want to, but in cell T2 im trying to get a tally of all the above mentioned cells, but it wont tally them it just keeps showing as zero.

PAULM03 · 05-09-2006, 21:05

Problem is exactly as Gaf said. Numbers in quotes are treated as plain text and wont be summed. e.g. you need to change "13" to 13 etc.

El_Stuart · 05-09-2006, 21:08

Ah poopdog, I'll give it a go

El_Stuart · 05-09-2006, 21:51

YES

She works, she works!!!!

Cheers fellas, mucho appreciated

05-09-2006, 20:31	#1 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 655	Microsoft excel...Help required Ok, heres the deal. I have an excel document that contains 7 rows of data i insert...I then have a series of IF sums that convert whatever i put into them to another figure (like doing ratings for something). Anyway it took me about 6 hours to get all that lot working but i still have a problem... ...I have another cell that i want to total up everything in the cells with the IF formula's in but it always shows the sum as 0 for some reason. Its as if the sheet isnt reading the cells as containing numbers, but they do... Anyone offer any help?

05-09-2006, 20:36	#2 (permalink)
PAULM03 Sabbatical punter Join Date: 27 Nov 2000 Age: 29 Posts: 10,487	Re: Microsoft excel...Help required Can you post an example? __________________ Try anything hard... there's nothing else you can do.

05-09-2006, 20:42	#3 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 655	Re: Microsoft excel...Help required OK, say i have 10 cells across the top, In these i insert how many goals a team scored in there last 10 games. The next 10 cells are calculated via IF calculations to translate these for me, say if its a 1 to assign 10 points to a corresponding cell and so on.....I want then to be able to have a final cell that calculates the new figures from the calculated cells but it wont have it. Id actually post an example here if i knew how

05-09-2006, 20:47	#4 (permalink)
GotaFancy?(BPP) God Punter Join Date: 18 Jun 2005 Posts: 35,277 Awards Showcase Total Awards: 4	Re: Microsoft excel...Help required Have you put the 10 points in the IF statement in quotes? It should be: If(A2=1,10,0) not If(A2=1,"10",0) Think that MAY be one possible explanation..... To put the example up, should be able to just copy and paste (in IE, not Firefox) __________________ Poker actually isn't about winning and losing, Poker is about making the right decision - Doyle Brunson - Opening sequence to Poker After Dark

05-09-2006, 20:52	#5 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 655	Re: Microsoft excel...Help required Ugh, I guess il hafta bust out IE (something i NEVER like doing). All the if calculations work ok, they are all sorted and i get a line of 10 new figures from the original data i enter and all is well....then when i set a cell to SUM all these new figures, it just always shows as 0... ..UGH, I HATE TECHNOLOGY!!!

05-09-2006, 20:56	#6 (permalink)
GotaFancy?(BPP) God Punter Join Date: 18 Jun 2005 Posts: 35,277 Awards Showcase Total Awards: 4	Re: Microsoft excel...Help required Can you copy and paste one of your formulas? You can do it in firefox __________________ Poker actually isn't about winning and losing, Poker is about making the right decision - Doyle Brunson - Opening sequence to Poker After Dark

05-09-2006, 21:01	#7 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 655	Re: Microsoft excel...Help required Ok i have formulas in cells L2 to Q2 that are calculated...... =IF(G2=0,"0",IF(G2<=3,"7",IF(G2=4,"13",IF(G2=5,"11",IF(G2=6,"8",IF(G2=7,"3",IF(G2>=8,"1","0"))))))) Now that gets the results i want to, but in cell T2 im trying to get a tally of all the above mentioned cells, but it wont tally them it just keeps showing as zero.

05-09-2006, 21:05	#8 (permalink)
PAULM03 Sabbatical punter Join Date: 27 Nov 2000 Age: 29 Posts: 10,487	Re: Microsoft excel...Help required Problem is exactly as Gaf said. Numbers in quotes are treated as plain text and wont be summed. e.g. you need to change "13" to 13 etc. __________________ Try anything hard... there's nothing else you can do.

05-09-2006, 21:08	#9 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 655	Re: Microsoft excel...Help required Ah poopdog, I'll give it a go

05-09-2006, 21:51	#10 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 655	Re: Microsoft excel...Help required YES She works, she works!!!! Cheers fellas, mucho appreciated

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Football Betting Tips	Australian Free Bets HOT	Free Bets	Odds Comparison	Soccer Punter
Bookmakers	Livescore	SoccerVista	Asian Handicap Betting Guide	Euroleague Betting Picks
Soccer Picks	Super-1