Excel formula question - The Punters Lounge

El_Stuart · 26-08-2007, 17:38

Its been a while since i asked a question so heres the annual query lol

I have a number in each cell in column P in my file, going down a list of football matches, the number is open ended and can be anything. What i want is for the cell in column T of each row to show me if the number is within a certain range.

If its greater than 1.00 i want to to say 'yes', and if its lower than -1.00 i want it to say 'no', if its anywhere in between i want it to stay empty.

I know about IF queries and such but wonder if its possible when im trying to use a certain range rather than a single number.

Muchos appreciado

GotaFancy? · 26-08-2007, 18:27

=if(P1>1,"Yes",if(P1<-1,"No",""))

That should do the trick in T1, then you can copy it down

El_Stuart · 26-08-2007, 18:32

Thanks GaF...Mucho appreciated, MrV said you'd be able to help me

26-08-2007, 17:38	#1 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 627	Excel formula question Its been a while since i asked a question so heres the annual query lol I have a number in each cell in column P in my file, going down a list of football matches, the number is open ended and can be anything. What i want is for the cell in column T of each row to show me if the number is within a certain range. If its greater than 1.00 i want to to say 'yes', and if its lower than -1.00 i want it to say 'no', if its anywhere in between i want it to stay empty. I know about IF queries and such but wonder if its possible when im trying to use a certain range rather than a single number. Muchos appreciado __________________ David Blaine is apparently gutted at the minute. He has discovered his 44 day record of doing sod all in a box has been smashed by Michael Owen.

26-08-2007, 18:27	#2 (permalink)
GotaFancy? God Punter Join Date: 18 Jun 2005 Posts: 33,105 Awards Showcase Total Awards: 4	Re: Excel formula question =if(P1>1,"Yes",if(P1<-1,"No","")) That should do the trick in T1, then you can copy it down

26-08-2007, 18:32	#3 (permalink)
El_Stuart Shrewdie Punter Join Date: 26 Feb 2006 Location: Middlesbrough Age: 27 Posts: 627	Re: Excel formula question Thanks GaF...Mucho appreciated, MrV said you'd be able to help me __________________ David Blaine is apparently gutted at the minute. He has discovered his 44 day record of doing sod all in a box has been smashed by Michael Owen.

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

Football Betting Tips	Free Bets	Australian Free Bets HOT	Odds Comparison	Soccer Punter
Bookmakers	Livescore	SoccerVista	Asian Handicap Betting Guide

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