Spreadsheet Excel Help

[stewartd14]

Right really looking for an Excel guru here as it is confusing and difficult enough to explain.

I have the following spreadsheet from my Glory Hunt thread (see sig)

DAY	STAKE	BACK/LAY	SELECTION	ODDS	WON/LOST	LIABILITY	PROFIT/LOSS	BANK
								£250.00
1	£50.00	Back	1+ Goals (Roma v Real Madrid)	1.11	WON	£50.00	£5.23	£255.23
1	£2.00	Lay	Chelsea/Olympiacos HT/FT	70	WON	£140.00	£1.90	£257.13
1	£3.00	Lay	Inter Milan to beat Liverpool	8.6	WON	£25.80	£2.85	£259.98
1	£3.00	Lay	Inter Milan to beat Liverpool	7.8	WON	£23.40	£2.85	£262.83
2	£5.00	Lay	Masked (3.35 Lingfield)	13	WON	£65.00	£4.75	£267.58
2	£2.50	Lay	Barcelona/Celtic HT/FT	65	WON	£162.50	£2.38	£269.95
2	£2.00	Lay	Jack Rolfe/Wicked Daze Rev Fcast	10	WON	£20.00	£1.90	£271.85
2	£4.00	Lay	Pajada (6.50 Kempton)	32	WON	£128.00	£3.80	£275.65
2	£2.50	Lay	Sharps Gold (7.50 Kempton)	14	WON	£35.00	£2.38	£278.03
2	£2.50	Lay	Adam Eterno (7.50 Kempton)	16.5	WON	£41.25	£2.38	£280.40
2	£5.00	Lay	Celtic to beat Barcelona	2.3	WON	£11.50	£4.75	£285.15
3	£3.00	Lay	Present (2.20 Huntingdon)	43.9	WON	£131.70	£2.85	£288.00
3	£4.00	Lay	Middleton Dene (3.25 Huntingdon)	12	WON	£48.00	£3.80	£291.80
3	£5.00	Lay	Steel Grey (5.10 Southwell)	22	WON	£110.00	£4.75	£296.55
3	£5.00	Lay	Maria Sharapova - Qatar Total Open	2.38	CURRENT	£11.90	£4.75	£301.30
3	£5.00	Lay	Tiger Woods - WGC Matchplay	3.2	CURRENT	£16.00	£4.75	£306.05

DAY is in Cell A1 and if anyone needs I can send them a copy of the spreadsheet.

See next post for what I want to do.

[stewartd14]

In column H (Profit), I have the formula:

=IF(C3="Back",((B3*E3-B3)*0.95),(B3*0.95))

This is taking into account wether C3 says BACK or LAY. I want to add into that formula, somehow, something that says

IF Cell F3 = "WON", then do formula above
IF Cell F3 = "LOSE", then do -(B3)
IF Cell F3 = "CURRENT", then do -(B3)

Basically I want another if statement saying if F3 = WON, do this. Otherwise, do this. However, I cant work out how to incorporate it into the other forumla. Did it a while ago but cant remember how I managed.

Secondly, I would like to do a lookup to give me my daily profit and my current liability. I dont have much of a clue about lookups so dont know if this is even possible.

Many Thanks, any help is greatly appreciated.

Stewart.

[GotaFancy?]

For the first one....
This does the trick I think - =IF(F3="WON",IF(C3="Back",((B3*E3-B3)*0.95),(B3*0.95)),-B3)
This checks whether "WON" is there or not - if you want it more specific to actually check for "LOSE" and "CURRENT" we need to add a bit, but for the moment, I assume you dont need to do that....

[GotaFancy?]

For the second one....

Have put "1" (without quotes) in cell K2
Then in L2 I've added: "=SUMIF(A:A,K2,H:H)"

That can be copied down for this output:

Day	Profit
1	£12.83
2	£22.33
3	£1.40

[stewartd14]

Brilliant GaF mate, many thanks. Think thats everything I need. Cheers.