I am trying to get excel keep track and total my football bets.
there are 5 different types of bets,and 3 differant results(w,l,p)
a b c d
1 TYPE OF PLAY WINNER LOSSER LOSSER/LOSSER
2 S 1 -1.1
3 P 2.33 -1
4 T 1 -1.2
5 3T 1 -1.4
6 R 4 -1.2 -1.1
7 day DATE PLAY AMOUNT TYPE RESULT TOTAL
8
this is the how i have it set up for now
any help would be great
Last edited by giejack; 08-08-2012 at 08:49 PM.
Hello giejack, and welcome to the forum.
Thanks for changing your thread title.
Last edited by Cutter; 08-08-2012 at 08:57 PM. Reason: Removed title change request
i hope this title is acceptable???
In reponse to PM:
To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.
what im trying to do is something like this. i will leave out the function commands being i have not idea which ones to use but you should be able to get the idea
i would want the formula in all the H column starting in row 8
f8="s",G8="w",e8*b2
f8="s",g8="L",e8*c2
f8="p",g8="w",e8*b3
f8="p",g8="L",e8*c3
f8="t",g8="w",e8*b4
f8="T",g8="L",e8*c4
f8="3T",g8="W",e8*b5
f8="3T,g8="L",e8*c5
f8="R",g8="W",e8*b6
f8="R",g8="LW",e8*c6
f8="R".g8="LL",e8*d6
g8="p"e8*0
It'll be your job to test - try this in H8
=IF(E8="","",E8*VLOOKUP(F8,$A$2:$D$6,IF(G8="w",2,IF(G8="l",3,4)),0))
i put that formula in and it just displays the formula in H8
doesnt give me an error or anything
Yes, I had the same problem. I don't know what you did to your sheet. Copy the whole range of cells containing anything, from A1 to whatever.
Go to Sheet2! and select A1, then Paste Special, Formulas
It should then start working.
toggle CTRL + ~ (it is actually the ` sign below the tilde, but that looks like a speck of dust on the screen, so i prefer using tilde, moreover i don't even know what that other thingy is called).
you have the file setup to show formula, instead of result.
Last edited by icestationzbra; 08-08-2012 at 10:36 PM.
- i.s.z -
CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
All good ideas are courtesy resources from this forum as well as others around the web.
- e.o.m -
thanks that works
all the varibles are covered but the TYPE "R" which are "W","LW","LL"
Thanks Ice, I forgot about that setting.
---------- Post added at 10:45 PM ---------- Previous post was at 10:41 PM ----------
I'm going to leave you in the more than capable hands of Ice. It's time for this head to hit a pillow.
ok and thanks for your help cutter
i have ran it and it is fully working
thanks again
Last edited by giejack; 08-08-2012 at 10:59 PM.
giejack, if you can setup your little tableau in a certain fashion (as illustrated in the attached file), your formula could be simplified. take a look at the attached file's "yellow" highlighted regions and see if it works for you.
ok thanks again
i have highlighted in red my next question.
i want to have a total for each day of the week how do i code that
can you explain with an example on your spreadsheet what you mean by 'total by the day of the week'? show some constituent numbers and final result and i will try to figure out how to formulate it using functions.
i have what im trying to do on the worksheet
if column M needs to be move that is fine
here you go (slight change in data):
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
giejack 
Register To Reply
Bookmarks