New Posts For Thread: excel helphttps://community.betfair.com/horse_racing/go/thread/view/94102/23880070/excel-helpgood morning folks. Could someone please help me with a formula I need on excel ( I'm not too good on it )If a cell has a W I need to multiply another cell by 5If the same cell has an L in it I need to multiply the other cell by -1This is probably clthank you matehttps://community.betfair.com/horse_racing/go/thread/view/94102/23880070/excel-help?post_id=430555262#430555262thank you mateWed, 14 Apr 2010 03:02:16 -0500I use OpenOffice not Excel so you might need to replace ; with , for it to work.https://community.betfair.com/horse_racing/go/thread/view/94102/23880070/excel-help?post_id=430555258#430555258I use OpenOffice not Excel so you might need to replace ; with , for it to work.Wed, 14 Apr 2010 03:01:53 -0500Not sure if the forum will format this properly, but anyway this does what you want.=IF(B136= "W" ;C136*5;IF(B136= "L" ;C136*-1;""))https://community.betfair.com/horse_racing/go/thread/view/94102/23880070/excel-help?post_id=430555254#430555254Not sure if the forum will format this properly, but anyway this does what you want.=IF(B136= "W" ;C136*5;IF(B136= "L" ;C136*-1;""))Wed, 14 Apr 2010 02:59:13 -0500good morning folks. Could someone please help me with a formula I need on excel ( I'm not too good on it )If a cell has a W I need to multiply another cell by 5If the same cell has an L in it I need to multiply the other cell by -1This is probably clhttps://community.betfair.com/horse_racing/go/thread/view/94102/23880070/excel-help?post_id=430555250#430555250good morning folks. Could someone please help me with a formula I need on excel ( I'm not too good on it )If a cell has a W I need to multiply another cell by 5If the same cell has an L in it I need to multiply the other cell by -1This is probably clWed, 14 Apr 2010 02:43:22 -0500