rounding to nearest 0.25p

[Guest]

I am trying to create a formula that rounds to the nearest 0.25p. Eg ((j10*1.04)) £2.18 increased by 4% = £2.27 want to round up to £2.50. Help pleas

 

[Frank Kabel]

Hi
try
=ROUND(J10/0.25,0)*0.25

 

[Guest]

Fran
I read your reply with interest its so simple! it works but I do not understand how
but will use in futur
Thank
Tina

 

[Bernie Deitrick]

Marie,

Once you say "round to the nearest", which Frank's solution does, and once
you say "Round up". For that you could use

=ROUNDUP(J10*4,0)/4

I use *4 instead of /.25 just to be different.... ;-)

HTH,
Bernie
MS Excel MVP

I am trying to create a formula that rounds to the nearest 0.25p. Eg

((j10*1.04)) £2.18 increased by 4% = £2.27 want to round up to £2.50. Help
please

 

[Frank Kabel]

Marie,

Once you say "round to the nearest", which Frank's solution does, and
once you say "Round up". For that you could use

=ROUNDUP(J10*4,0)/4

I use *4 instead of /.25 just to be different.... ;-)

Frank