Hi,
Our Company has a load of Filling Stations they supply, and they wanted to use an auto roundup or down in a spreadsheet to change daily fluctuations in pricing to the sites.
ie if todays price was 98.25 it should round down to 98.00 if it was 98.67 it would round up to 98.90
Anyone any idea how to work that out? I've been reading about Round Max and Ceiling but they dont round after the decimal point or from what my limited knowledge in coding can fathom out.
Any ideas anyone?
Thanks
Sorry I made an arse of it as I was in a hurry to go out somewhere else.
It should round up or down to the nearest 0.9
If its a low price like 98.25 it should round down to 97.90 or if its above 98.51 then should round up to 98.90
Apologies for the confusion.