Hi Doc,

Format cell A2 (or any others used in your weight answer) as number with two decimal places.

Then type into cell A2
=MROUND(A1/11.5,0.25)

I have only run it on a few examples...it should work fine.

If you get an answer which is #VALUE!, then make sure you have all the addins installed for Excel.

__________________
RaceCensus - powerful system testing software.
Now with over 413,000 Metropolitan, Provincial and Country races!
http://www.propun.com.au/horse_raci...ng_systems.html
*RaceCensus now updated to 31/01/2025
Video overview of RaceCensus here:
http://www.youtube.com/watch?v=W821YP_b0Pg

Thanks Chrome, it works just the way I wanted.

I'm using the spreadsheet for my daily racing. But the formula i have posted and the in the attachment don't work. They are different.

I'm sorry if i didn't explain my request properly.

Benny

Chrome, if your out there somewere I have one further prob. Now that I have my final rating figure running down column f on my spreadsheet in TAB no order,I now wish to subtract the final figure for each horse from the highest figure in column F so that in the cells in column G I will have the difference in KGs from the highest rater if you know what I mean. The thing is that I would like to keep them in TAB order as well. Ive tried the help function but cant seem to find exactly what Im looking for.

Hi Dr Ron,

If your ratings are in cells F1 down to F24, try typing the following into G1:

=(MAX(F$1:F$24))-F1

Then drag the formula down to G24.

Good luck.

Cheers,

H.

Thanks for that H I'll give it a try.

Heavyweight, didnt quite work , but I messed around a little and got what I was after thanks, You put me on the right track.

One last problem now, I now have the margins in kgs in column H, so in the cells next to them in column i I need the formula to say that if H1=0 then 100 points, if H1=0.5 then 90 points if you get my drift.

dr ron, the easiest way probably is to use "lookup" functions, so in an unused area of the worksheet, for example at AA1 enter 0, AA2 enter .05 & so on, in cell AB1 enter 100, AB2 enter 90 & so on. then create a lookup function in cell I1 which will look something like this -

=LOOKUP(H1,AA$1:AA$11,AB$1:AB$11) & copy it down to cell I2 & so on.

basically it looks at the value in cell H1, finds that value in the cell range AA1 to AA11 & reports the value of the neighbouring cell in the range AB1 to AB11.

note that the ranges AA1 to AA11 & AB1 to AB11 will vary depending on how large your kg & points list is.

if the above makes no sense you are welcome to email me your spreadsheet & i will setup for you.

mango_madness@bigpond.com

Thanks Davez, suprisingly it does make sense to me as it is exactly what I wanted. I will put it in and see how it goes. If it dosent work I will take you up on your kind offer.

Works a treat, thanks Davez, thanks to all who have helped me, my spreadsheet is now up and running. Not the tidiest piece of work, but it does the job i want. it will certainly save me the pen and paper work.