Excel Techy Question - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

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
ACE1987 Avatar
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
ACE1987 Avatar
8y, 10m agoPosted 8 years, 10 months ago
Options

All Comments

(8) Jump to unreadPost a comment
Comments/page:
#2


not quite right needs to be:

=FLOOR(A1,0.5)

drag the formula down and then change to currency with 2 decimal places
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
Shouldn't your last answer be £1007.00
#6
Jumpingphil
Shouldn't your last answer be £1007.00


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

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!