Get instant live expert help on I need help with target profit formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Hi, I need help with a formula to work out target betting on horse races. I put in a number, say 50 bucks as a target profit, and then the odds over the next five races, which can change constantly. The other boxes then tell me how much to bet on the following races to achieve my target of 50 dollars profit for that day, including and allowing for any previous losses. Thanks
Solved by B. A. in 25 mins
Need to fix the formula in the protab Sunshine section use the formula of sumif . Basically target sheet is combining the data as Target column get the data from the target sunshine sheet and in sold column get the data from info-sale sunshine sheet and difference is. Sold-target.
Solved by V. B. in 23 mins
I need a formula that shows in which quarters did the verticals start beating target. Where they beat target, which weeks do they start becoming the most accurate? In quarters where the miss target, which weeks?
Solved by K. W. in 29 mins
looking for formula in column AG5. If AF5="running" and x5="sell", and E5<AE5 then AG5= "target hit","" if af5="running" and x5="buy", and D5>AE5 then AG5= "target hit","" UNLESS AG4 ="target hit", then AF5="blank"
Solved by G. H. in 14 mins
In the Profit Analysis Worksheet: a. In the first cell directly under the Profit label, calculate total profit by subtracting Expenses from revenue (should be a positive number). (Revenue Expenses). Then repeat the formula for each row below. b. In the first cell directly under the ProfitperCar label, divide Profit by NumCars (Profit/Numcars). Then repeat the formula for each row below. c. Adjust column widths as needed to eliminate truncation after formatting.
Solved by V. C. in 26 mins