I am trying to round currency figures up and down to the nearest
5pence/10pence etc etc How do I round up to these. What is the formula
I need to use. Please Help!!


--
milsupport
------------------------------------------------------------------------
milsupport's Profile: http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

did you try to use ROUND?

regards

"milsupport" escreveu:


I am trying to round currency figures up and down to the nearest
5pence/10pence etc etc How do I round up to these. What is the formula
I need to use. Please Help!!


--
milsupport
------------------------------------------------------------------------
milsupport's Profile: http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

=ROUND(A1/5,0)*5
=ROUND(A1,-1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"milsupport" wrote
in message ...

I am trying to round currency figures up and down to the nearest
5pence/10pence etc etc How do I round up to these. What is the formula
I need to use. Please Help!!


--
milsupport
------------------------------------------------------------------------
milsupport's Profile:
http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

No, how does that go =ROUND...... Brackets?? 0.5?

Regards


--
milsupport
------------------------------------------------------------------------
milsupport's Profile: http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

for eg

if you have an amount as $123,14, and you would like to round to $123,10

just =round(123,14,1)

regards

"milsupport" escreveu:


No, how does that go =ROUND...... Brackets?? 0.5?

Regards


--
milsupport
------------------------------------------------------------------------
milsupport's Profile: http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

Ok still not sure and cant get it to work, for example I have (Starting
in A1)

11.47
15.59
14.44

Wanting to round up to teh nearest 5 PENCE

To read in B1 etc

11.50
15.60
14.45

And so on

Cant get my head round it

Regards

M


--
milsupport
------------------------------------------------------------------------
milsupport's Profile: http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

=ROUND(A1*20,0)/20

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"milsupport" wrote
in message ...

Ok still not sure and cant get it to work, for example I have (Starting
in A1)

11.47
15.59
14.44

Wanting to round up to teh nearest 5 PENCE

To read in B1 etc

11.50
15.60
14.45

And so on

Cant get my head round it

Regards

M


--
milsupport
------------------------------------------------------------------------
milsupport's Profile:
http://www.excelforum.com/member.php...o&userid=34945
View this thread: http://www.excelforum.com/showthread...hreadid=546800

Hello Bob,

Shorter :-)

=ROUND(A1*2,1)/2

or

=ROUND(A1/5,2)*5

Have fun,
Bernd

I was being pedantic Bernd <g. Following the actual logic of the process.
Need to step back.

I think your second version is the best, it easily translates to other
thresholds.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

wrote in message
oups.com...
Hello Bob,

Shorter :-)

=ROUND(A1*2,1)/2

or

=ROUND(A1/5,2)*5

Have fun,
Bernd