Hi,
Wondering if somebody can help me with a problem.
I'm trying to create a formula within the BetAngel_1.xls spreadsheet where if there is less than £500 in a particular cell a Back or Lay bet is fired in but I'm having trouble writing it.
So for example if cell G10 has less than £500 place a Lay bet =IF(G10<500,"LAY","")
I don't know how to input the currency so that the formula will work.
On a different note is there a way to change the spreadsheet so it shows the first 5 prices in the market instead of the first 3?
Thanks
IF Function help
-
RonObvious
- Posts: 198
- Joined: Mon Dec 09, 2013 4:12 pm
Yeah sorry I see the mistake I was making now, I didn't have the odds field filled in! 
One last question though is there a way of putting 2 conditions, both a back and a lay condition in on the same line?
So =If(G10<500,"LAY","") & =If(H10<500,"BACK","")
The idea behind it is to be able to fire orders in on both sides of the book if conditions are met. I've tried but just get the text FALSE.
And so not to bother you all everytime I have a question If I wanted to create a spreadsheet from scratch what videos should I be looking at?
Excel is Fun on youtube seems pretty comprehensive but I'd have no idea where to start! VBA, Macros etc....
Thanks again
One last question though is there a way of putting 2 conditions, both a back and a lay condition in on the same line?
So =If(G10<500,"LAY","") & =If(H10<500,"BACK","")
The idea behind it is to be able to fire orders in on both sides of the book if conditions are met. I've tried but just get the text FALSE.
And so not to bother you all everytime I have a question If I wanted to create a spreadsheet from scratch what videos should I be looking at?
Excel is Fun on youtube seems pretty comprehensive but I'd have no idea where to start! VBA, Macros etc....
Thanks again
-
RonObvious
- Posts: 198
- Joined: Mon Dec 09, 2013 4:12 pm
Hi Linus,
Sorry I probably didn't explain it right.
=If(G10<500,"LAY","BACK") would work for one cell on one side of the book but I want the Lay for cell G10 and the back for cell H10 if the conditions are met so both sides of the book are covered if the conditions are met
Sorry I probably didn't explain it right.
=If(G10<500,"LAY","BACK") would work for one cell on one side of the book but I want the Lay for cell G10 and the back for cell H10 if the conditions are met so both sides of the book are covered if the conditions are met
Hello Ron,
This should do it:
=IF(G10<500,"LAY",(IF(H10<500,"BACK","")))
It's called a nested IF function and will look for the 2nd function if the first is not true - ie. priority is given to the lay bet if they are both true.
I am self-taught on excel from google, you should find that it is pretty intuitive and after a while you just treat each new thing that you want to do as a puzzle.
This should do it:
=IF(G10<500,"LAY",(IF(H10<500,"BACK","")))
It's called a nested IF function and will look for the 2nd function if the first is not true - ie. priority is given to the lay bet if they are both true.
I am self-taught on excel from google, you should find that it is pretty intuitive and after a while you just treat each new thing that you want to do as a puzzle.
-
RonObvious
- Posts: 198
- Joined: Mon Dec 09, 2013 4:12 pm
Many thanks Lee,
The formula is perfect but what should I put in the odds cell?
G10 is the amount so I'd want a lay bet fired in at whatever the odds are in G9 but because there's the odds on the back side as well (cell H9) how could I put both in the value cell?
I've tried G9:H9 but the cell just says #VALUE!
The formula is perfect but what should I put in the odds cell?
G10 is the amount so I'd want a lay bet fired in at whatever the odds are in G9 but because there's the odds on the back side as well (cell H9) how could I put both in the value cell?
I've tried G9:H9 but the cell just says #VALUE!