Simple question

Please post any questions regarding the program here.

Moderator: 2020vision

Simple question

Postby Des911 » Tue Aug 25, 2009 2:34 pm

Hi all, just started on this excel thing so forgive me.

I've searched this forum and a fair bit on the internet but can't find the answer. What does the $ do in excel and is there a list of all the functions anywhere.

Again, apologies and thanks for any help.
Des911
 
Posts: 42
Joined: Sat Jul 19, 2008 8:56 pm

Postby Yorkie » Tue Aug 25, 2009 3:08 pm

Hi
Can't help you with a list of functions, maybe someone else can but the $ i can help with.

Lets say you put the formula in cell AB15 =IF(Z15<=AK13,1,0)

In this formula AK13 is a reference cell.

If I copy cell AB15 to cell AB16 then it would become =IF(Z16<=AK14,1,0)

I don't want this as i want the AK13 to remain constant.
By changing the formula to =IF(Z15<=$AK$13,1,0) when I copy the cell AB15 to AB16 the formula put into cell AB16 is =IF(Z16<=$AK$13,1,0)

I other words it locks that cell into the formula when you copy it to anywhere else.

Did that make sense?.lol
Yorkie
 
Posts: 116
Joined: Wed Feb 25, 2009 1:04 pm

Postby Des911 » Tue Aug 25, 2009 3:17 pm

Many thanks, that explains it.

What I am looking at is trying to lay the 2nd fav at cetrain odds and I've modified the lay fav spreadsheet, which is under the Sample Triggered Betting Excel Sheets section with the line

=IF(AND(AA5=2,H5<2,$F$2="",COUNTBLANK(T$5:T$50)=46),"LAY","")

and so wondered what the $ sign is for.

Perhaps you could explain the above line for me. I get the if AA5 = 2 (2nd fav - 2nd in the rank) and H5 <2 (odds under 2.0) and LAY but the rest is a mystery.
Des911
 
Posts: 42
Joined: Sat Jul 19, 2008 8:56 pm

Postby KevinTHFC » Tue Aug 25, 2009 7:44 pm

=IF(AND(AA5=2,H5<2,$F$2="",COUNTBLANK(T$5:T$50)=46),"LAY","")

IF AA5=2 AND H5<2 AND F2 is empty AND T5 to T50 are empty THEN put LAY into the cell else BLANK the cell
KevinTHFC
 
Posts: 72
Joined: Fri Aug 25, 2006 9:08 pm

Postby mak » Tue Aug 25, 2009 9:12 pm

Hi, if you click in the excel toolbar at the fx (beside where you can write a formula) you can see a list of functions & the syntax

Hope to make sense
mak
 
Posts: 1086
Joined: Tue Jun 30, 2009 8:17 am

Postby osknows » Tue Aug 25, 2009 9:51 pm

A quick tip which I have found very useful in excel

if you enter into any cell the formula =A1,
Press F4 once and you get =$A$1, twice =A$1, three times =$A1 etc

This works for any part of the formula next to the cursor in the formula bar
User avatar
osknows
 
Posts: 946
Joined: Wed Jul 29, 2009 12:01 am

Postby Des911 » Wed Aug 26, 2009 2:47 pm

Thanks for all your help, I know it's simple but we all have to start somewhere :?
Des911
 
Posts: 42
Joined: Sat Jul 19, 2008 8:56 pm

Postby throwmeadisc » Thu Aug 27, 2009 11:12 am

osknows wrote:A quick tip which I have found very useful in excel

if you enter into any cell the formula =A1,
Press F4 once and you get =$A$1, twice =A$1, three times =$A1 etc

This works for any part of the formula next to the cursor in the formula bar


wow, you do learn something everyday!! :wink:

Al 8)
User avatar
throwmeadisc
 
Posts: 165
Joined: Fri Dec 14, 2007 11:06 am
Location: London, UK

Postby Norwegian Would » Fri Aug 28, 2009 11:21 am

@Des911.

If you need any books about Excel (pdf files) _
Excel for dummies
Excel 100 tips etc etc........

PM me and I can send you some files to get you started,

I also recommend MrExcel.com - Quick ; easy tips.

Good Luck
User avatar
Norwegian Would
 
Posts: 43
Joined: Sat Jul 11, 2009 10:18 pm
Location: Bergen-by-the-Sea; Norway


Return to Help

Who is online

Users browsing this forum: No registered users and 22 guests

Sports betting software from Gruss Software


The strength of Gruss Software is that it’s been designed by one of you, a frustrated sports punter, and then developed by listening to dozens of like-minded enthusiasts.

Gruss is owned and run by brothers Gary and Mark Russell. Gary discovered Betfair in 2004 and soon realised that using bespoke software to place bets was much more efficient than merely placing them through the website.

Gary built his own software and then enhanced its features after trialling it through other Betfair users and reacting to their improvement ideas, something that still happens today.

He started making a small monthly charge so he could work on it full-time and then recruited Mark to help develop the products and Gruss Software was born.

We think it’s the best of its kind and so do a lot of our customers. But you can never stand still in this game and we’ll continue to improve the software if any more great ideas emerge.

cron