Hi,

Am Fri, 4 May 2012 19:15:07 +0000 schrieb stumjumper:

Example 176 round up to 179
173 round up to 179
161 round up to 169

try:
=ROUNDUP(A1*(1+B1)/10,0)*10-1


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2