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

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

.... change to

=IF(A1<>0,INT(A1*(1+B1))+0.95,"") if you nil values to return blank

"Toppers" wrote:

> 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