Help with a formula please.

[Guest]

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.

 

[Guest]

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

 

[Guest]

.... change to

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