(Firstly no pun intended in the thread title - I didn't choose my surname 
)
I have a spreadsheet to calculate selling prices from cost prices. Such as:
Cost Price X Factor = Selling Price
However I want to round up the selling price to the next whole number ending in 9. So I want to round up prices like:
72.78, 55.54, 66.89, 112.40 to
79, 59, 69 119 etc.
There is an exception though I only want to do this if the number is within 7 of the rounded up number otherwise it needs to be rather rounded down to the nearest 9.
For example a price of say 119.89 should be 119 and a price of 121.25 should be 119 yet 122.55 would be 129.
I'm trying to devise an Excel cell formula to do this - any Excel wiz out there willing to give it a go?
)I have a spreadsheet to calculate selling prices from cost prices. Such as:
Cost Price X Factor = Selling Price
However I want to round up the selling price to the next whole number ending in 9. So I want to round up prices like:
72.78, 55.54, 66.89, 112.40 to
79, 59, 69 119 etc.
There is an exception though I only want to do this if the number is within 7 of the rounded up number otherwise it needs to be rather rounded down to the nearest 9.
For example a price of say 119.89 should be 119 and a price of 121.25 should be 119 yet 122.55 would be 129.
I'm trying to devise an Excel cell formula to do this - any Excel wiz out there willing to give it a go?
Comment