Groups

# Excel Techy Question

Need a formulae in excel to do the following.

I have 50,000 principle values than need to be rounded down to £0.50.

Example:
£12.21 would = £12.00
£202.76 would = £202.50
£1007.49 would = £1007.00

Any help much appreciated

gemz700;2634838

this might … this might helphttp://www.viloria.com/secondthoughts/archives/00000775.html

not quite right needs to be:

=FLOOR(A1,0.5)

drag the formula down and then change to currency with 2 decimal places

Banned

king261;2634960

not quite right needs to be:=FLOOR(A1,0.5) drag the formula down and then … not quite right needs to be:=FLOOR(A1,0.5) drag the formula down and then change to currency with 2 decimal places

Yeah that works. It would also be possible to rounding to the nearest 50p if needed

Jumpingphil;2635941

no coz its to the nearest 50p

TWIGGY4LIFE 666;2635973

no coz its to the nearest 50p

It's rounded down to the nearest 50p so the answer ends in 0 or 50p.

If its to the nearest 50p then it would be £1007.50.

Original Poster

Sorry everyone.. my requirement is down to 0.50p... so the answer should have been 1007.00

Think i've managed to crack it now.. although for some reason my formula is alot beigger than these lol.

Many Thanks