New Posts For Thread: Excel help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-pleaseJust getting my spread sheets ready for the flat, am self taught so need some help that may seen obvious to some.if cell p18 is Q A, I want cell q18 to have the number 40 in it.Also, if cell p18 is S A cell q18 to be -20tiaGGRand thanks to you too compound.I won´t live long enough to learn how to do these formulas!!https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131314#420131314and thanks to you too compound.I won´t live long enough to learn how to do these formulas!!Sat, 06 Feb 2010 02:41:48 -0600Beat me to it loriYou've done that to me beforeCheershttps://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131298#420131298Beat me to it loriYou've done that to me beforeCheersSat, 06 Feb 2010 02:24:40 -0600=IF(P18="AL",40,IF(P18="QA",30,IF(P18="PR",20,IF(P18="HU",-10,IF(P18="SA",-20,"")))))Enter into Q18https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131294#420131294=IF(P18="AL",40,IF(P18="QA",30,IF(P18="PR",20,IF(P18="HU",-10,IF(P18="SA",-20,"")))))Enter into Q18Sat, 06 Feb 2010 02:23:02 -0600many thanks lorithat is a proper formula!!https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131286#420131286many thanks lorithat is a proper formula!!Sat, 06 Feb 2010 02:14:02 -0600=IF(P23="AL",40,IF(P23="QA",30,IF(P23="PR",20,IF(P23="HU",-10,IF(P23="SA",-20,"others")))))https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131282#420131282=IF(P23="AL",40,IF(P23="QA",30,IF(P23="PR",20,IF(P23="HU",-10,IF(P23="SA",-20,"others")))))Sat, 06 Feb 2010 02:12:40 -0600any chance you can do all these in cell p18 and q19https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131278#420131278any chance you can do all these in cell p18 and q19Sat, 06 Feb 2010 02:07:47 -0600IFAL 40QA 30PR 20HU -10SA -20any chance you can do all these in cell p18 and p19pleasePretty pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131274#420131274IFAL 40QA 30PR 20HU -10SA -20any chance you can do all these in cell p18 and p19pleasePretty pleaseSat, 06 Feb 2010 02:00:25 -0600Thanks all, I will give it a wizz after brekkiehttps://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131254#420131254Thanks all, I will give it a wizz after brekkieSat, 06 Feb 2010 01:14:04 -0600oops, I did the same with the -20https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131250#420131250oops, I did the same with the -20Sat, 06 Feb 2010 01:10:29 -0600typo from me also =IF(P18="QA";40;IF(P18="SA";-20;""))https://community.betfair.com/general_betting/go/thread/view/94082/23512522/excel-help-please?post_id=420131246#420131246typo from me also =IF(P18="QA";40;IF(P18="SA";-20;""))Sat, 06 Feb 2010 01:10:12 -0600