Hi,

Im trying to work out a formula to automatically round price points to set amounts (e.g. nearest x.49 or nearest x.99). Is there anyway of doing this via excel?

So, for example my base price formula arrives at figure of 5.62 it automatically rounds it to 5.49 or if the base price is 8.19 it rounds it down to 7.99