New Posts For Thread: Excel formula help pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-pleasemorning folks, any help would be appreciated.How can I deduct one value from another when a certain date happens. Basically at the end of the month I need to calculate profit/lossSo it would be IF cell A = 31May then deduct cell B from cell C. Couldforhttps://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-please?post_id=449216569#449216569forWed, 26 May 2010 04:54:12 -0500cheers fot that compoundhttps://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-please?post_id=449216541#449216541cheers fot that compoundWed, 26 May 2010 04:53:43 -0500A formula so you don't have to find the date value =IF(EOMONTH(A3,0)=A3,C3-B3,"")https://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-please?post_id=449212237#449212237A formula so you don't have to find the date value =IF(EOMONTH(A3,0)=A3,C3-B3,"")Wed, 26 May 2010 03:28:02 -0500thanks bongo, much appreciatedhttps://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-please?post_id=449210741#449210741thanks bongo, much appreciatedWed, 26 May 2010 02:57:48 -0500A starter answer, better will come I'm sure:In cell A1 put =TODAY()Cell B1 - expenditureCell C1 - incomeIn Cell D1 put =IF(A1>40328,C1-B1,"")or possibly =IF(A1=40329,C1-B1,"")40329 being excel's date value for 31/05/2010good luckhttps://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-please?post_id=449210493#449210493A starter answer, better will come I'm sure:In cell A1 put =TODAY()Cell B1 - expenditureCell C1 - incomeIn Cell D1 put =IF(A1>40328,C1-B1,"")or possibly =IF(A1=40329,C1-B1,"")40329 being excel's date value for 31/05/2010good luckWed, 26 May 2010 02:53:14 -0500morning folks, any help would be appreciated.How can I deduct one value from another when a certain date happens. Basically at the end of the month I need to calculate profit/lossSo it would be IF cell A = 31May then deduct cell B from cell C. Couldhttps://community.betfair.com/general_betting/go/thread/view/94082/24881833/excel-formula-help-please?post_id=449205653#449205653morning folks, any help would be appreciated.How can I deduct one value from another when a certain date happens. Basically at the end of the month I need to calculate profit/lossSo it would be IF cell A = 31May then deduct cell B from cell C. CouldWed, 26 May 2010 01:22:06 -0500