Excel Techy Question - HotUKDeals
Get the HotUKDeals app free at Google Play

#### Search Error

An error occurred when searching, please try again!

# Excel Techy Question

£0.00 @
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 = £10… Read More
8y, 10m agoPosted 8 years, 10 months ago
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
8y, 10m agoPosted 8 years, 10 months ago
Options

(8)
#2

not quite right needs to be:

=FLOOR(A1,0.5)

drag the formula down and then change to currency with 2 decimal places
#3
banned#4
king261
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
#5
#6
Jumpingphil

no coz its to the nearest 50p
#7
TWIGGY4LIFE 666
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.
#8
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