What formula can I use for bonus bets to calculate the net return $? I want to add them into the bets table but when I do it calculates the profit wrong BECAUSE Bonus bets don’t pay out the initial wager just the payout, i tried doing a negative number for the wager but it doesn’t work either, is there a way to add something to the formula that states if( - )wager then don’t take wager into net $ , as you only get the payout minus your wager since it was a bonus bet ? Hopefully this makes sense let me know if you have any thoughts please ?
Great video, but why wen i try to select a cell when doing the calculations it shows "Table4[@;[Paid $]]"? and not "[@[Paid $]]" Doing it manually fixes it but i don't understand why i can't just select the cell i want. Thanks
Created this account and purchased your NBA model a few moments ago. Just wanted to say thanks for taking the time to put out the content.
Really nice and easy walk through to follow 👌
Thanks for the positive feedback!
Love this just started doing this tonight!
Great, hope it works out well for you!
Good evening
Is there anything similar for table tennis?
Congratulations on the work done
What formula can I use for bonus bets to calculate the net return $? I want to add them into the bets table but when I do it calculates the profit wrong BECAUSE Bonus bets don’t pay out the initial wager just the payout, i tried doing a negative number for the wager but it doesn’t work either, is there a way to add something to the formula that states if( - )wager then don’t take wager into net $ , as you only get the payout minus your wager since it was a bonus bet ?
Hopefully this makes sense let me know if you have any thoughts please ?
Great video. I'm in the UK how do I change the formula to decimal in the odds table please
Thanks, there is no formula change needed just format your odds column to be Decimal instead of American Odds
Great video, but why wen i try to select a cell when doing the calculations it shows "Table4[@;[Paid $]]"? and not "[@[Paid $]]" Doing it manually fixes it but i don't understand why i can't just select the cell i want. Thanks
Is the title of your table you are logging your bets in "Table4"?
hey man. if i purchase this on etsy is it availible to use with decimal odds or it only moneyline.
You will get both a decimal odds and American odds version with your purchase!
Does this translate to Google Sheets as well after download or strictly Excel?
Only works with Excel
How can I have a copy of your spreadsheet?
www.etsy.com/listing/1432035096/sports-betting-tracker-with-dynamic