I need to be able to round up the values to the next multiple of 50 cents, eg 336 to $3.50. Thi is used in calculating the minimum value of bets in doubles, trebles, quadrellas and trifectas in Australian horse race betting. If the combinations of selections comes to say 336, I need to calculate the round up value to $3.50. Similarly 489 combinations would be rounded up to $5. I have attached a simple spreadsheet which details what is wish to achieve. At least I downloaded it but then closed the window as I have no option other than that to get out of the program. I assume it downloads but if not, the issue is adequately explained above.
Trusting someone may be able to help.
Thanking you.
Peter Campbell
Bookmarks