We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
morning 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/loss
So it would be IF cell A = 31May then deduct cell B from cell C. Could someone help with the formula please
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/loss
So it would be IF cell A = 31May then deduct cell B from cell C. Could someone help with the formula please
Show More
A starter answer, better will come I'm sure:
In cell A1 put =TODAY()
Cell B1 - expenditure
Cell C1 - income
In Cell D1 put =IF(A1>40328,C1-B1,"")
or possibly =IF(A1=40329,C1-B1,"")
40329 being excel's date value for 31/05/2010
good luck
In cell A1 put =TODAY()
Cell B1 - expenditure
Cell C1 - income
In Cell D1 put =IF(A1>40328,C1-B1,"")
or possibly =IF(A1=40329,C1-B1,"")
40329 being excel's date value for 31/05/2010
good luck
A formula so you don't have to find the date value
=IF(EOMONTH(A3,0)=A3,C3-B3,"")
=IF(EOMONTH(A3,0)=A3,C3-B3,"")
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539