Help with a formula please.
 

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

Help with a formula please.
 

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

Help with a formula please.
 

.... 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