Although common this can get a little complicated.
if you are sure that 2.00 = 2.09 then
for value in A1 put this formula where you want the answer
extra brackets for clarity....INT returns the integer

=(INT((10*A1)+1))/10)-.01

"Mr. Knobb" wrote:

I'm calculating retail prices at various gross profit percentages. I do this
by dividing the cost by the reciprocal of the desired GP%. I want the
results to always round up to the nearest 9, e.g. $3.29, 5.49, 2.99, etc.
How's this done?