Hi Stugots,

Thanks for replying. I don't seem to be explaining the problem very well.

In column D I have various Horse's Rated figures If I want to see how many units I need to place on that horse to collect $100 I enter into column E1 the formula =100/D1 and copy this down column E to get the units for all horses.

My question is if this formula is already in Column E is it possible to also enter in column E the ROUNDUP formula so all units are whole numbers taken to the next whole number?

Hope this makes the problem clearer.