New Posts For Thread: Excel Help Urgently neededhttps://community.betfair.com/general_betting/go/thread/view/94082/23494962/excel-help-urgently-neededI have spent ages trying to work out the calculation to work something out. Any help would be appreciated.Here goes :-=IF(AM7="Y",IF(AE7>50,(K7*0.5),0),0)In the above calculation if Cell AE7 is Higher than 50 it ensures cell K7 is multilied by .5What.https://community.betfair.com/general_betting/go/thread/view/94082/23494962/excel-help-urgently-needed?post_id=419716982#419716982.Fri, 22 Jan 2010 15:24:22 -0600Guys. a million thanks , you can always rely on a Betfarian to get you out the **.Much appreciated guysThanks Again, have a great xmashttps://community.betfair.com/general_betting/go/thread/view/94082/23494962/excel-help-urgently-needed?post_id=419716858#419716858Guys. a million thanks , you can always rely on a Betfarian to get you out the **.Much appreciated guysThanks Again, have a great xmasTue, 19 Dec 2006 13:50:44 -0600Replace AE7>50withAND(AE7>50,AE7= ANDhttps://community.betfair.com/general_betting/go/thread/view/94082/23494962/excel-help-urgently-needed?post_id=419716854#419716854Replace AE7>50withAND(AE7>50,AE7= ANDTue, 19 Dec 2006 13:37:22 -0600Use AND=IF(AM7="Y",IF(AND(AE7>50,AE7https://community.betfair.com/general_betting/go/thread/view/94082/23494962/excel-help-urgently-needed?post_id=419716850#419716850Use AND=IF(AM7="Y",IF(AND(AE7>50,AE7Tue, 19 Dec 2006 13:36:02 -0600I have spent ages trying to work out the calculation to work something out. Any help would be appreciated.Here goes :-=IF(AM7="Y",IF(AE7>50,(K7*0.5),0),0)In the above calculation if Cell AE7 is Higher than 50 it ensures cell K7 is multilied by .5Whathttps://community.betfair.com/general_betting/go/thread/view/94082/23494962/excel-help-urgently-needed?post_id=419716846#419716846I have spent ages trying to work out the calculation to work something out. Any help would be appreciated.Here goes :-=IF(AM7="Y",IF(AE7>50,(K7*0.5),0),0)In the above calculation if Cell AE7 is Higher than 50 it ensures cell K7 is multilied by .5WhatTue, 19 Dec 2006 13:22:55 -0600