Do you always round up or down?

127*1.53=194.31 ==> 193.95 or 194.95?
137*1.53=209.61 ==> 208.95 or 209.95?

If it up, take integer value and add 0.95

A1=Value
B1=%

=IF(A1<>0,INT(A1*(1+B1))+0.95,0)

Round down

=IF(A1<>0,INT(A1*(1+B1)-1)+0.95,0)

HTH

"Rory" wrote:

> Can anyone write a formula to do the following,
> Add 53 % to a cell with a figure in it then round of the pence to 95 ie
> 101.95 also if possible if i drag down a coloum of figures to apply the
> formula to, ignore any cells in the coloum with have a nil value.
> Thanks in Advance.
> --
> Rory Moore