Need to calculate formula of multiple amounts

[pricey74]

I have a program I use on my pc which calculated how much money is needed to wager on a horse to win a certain amount profit for each race, its a program used by professional punters for years. I have used it for the follwoing 3 years with great success but I was wondering if it is possible to break down the formula so it can be done on a excel spreatsheet that way I can use it when I am at the track on my phone instead of tring to work it out on the fly with a calculator ect.
This is the basics of the program you put in a cell how much you want to win profit for each race eg $100, in another cell you put in what the fixed odds are for the horse you are backing eg 5 - 1, so it tells you to bet $25 to win $125 with a profit of $100 then in another cell there is a drop down box with win or lose in it,sounds easy this is where it gets harder. if the horse wins it just starts again for the next race if the horse loses it calculates how much is needed on the next horse to win you profit margin of $100 per race plus any money you have outlayed on previous losing races ie $100 profit per race = $200 (2 races) and money outlayed already $25 then calculates how much you need to place on the next horse to win that amount plus your wager on this race to recoup all outlays plus $100 per race profit. (hope this is not too confusing) say horse is 6 - 1 then you will need to outlay $45 at 6 -1 to win $270 which gives you your $200 profit plus the $45 + $25 you have outlayed on both races ect. If anyone thinks they know of a way to write this formula I would be very interested in how, I have a fair knowledge of excel but this is out of my depth. I can also email a copy of the program to give you a better idea of how it works if it helps
Thanks Shayne

[arthurbr]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST