If that's what you want, try =MROUND(A2,0.2) or =0.2*ROUND(A2/0.2,0)

I hope that you realise that what you are asking for now is nothing like
what you originally asked for. The usual situation on this group is that
finding the answer is easy, but finding the question is difficult.
--
David Biddulph

"M.A.Tyler" <Great Lakes State wrote in message
...
I thought so at first, but it's not exactly what I'm looking for. It is
very
close and perhaps the best I could expect. the perfect solution would
treat
.10 as .20, so you would never have an odd number .30, .50,.70,.90. For
expmple between 1 & 2 you would have only .20,.40,.60,.80 then 2.0,
counting
by fifths.

Perhaps it's not possible?

M.A.

"MartinW" wrote:

Hi MA,

Sorry for the confusion, but doesn't Chip Pearson's reply
about DOLLARDE and DOLLARFR solve your problem?

HTH
Martin


"M.A.Tyler" <Great Lakes State wrote in message
...
Yes!, can you help?

"Bob I" wrote:

Umm, fifths would be .0, .2, .4, .6, and .8 so what is it you really
want? .5 is equal to 2 and 1/2 "fifths" not one.

M.A.Tyler wrote:

Sorry, I would like a method to calculate simple mathmatical
problems
using
the decimal portion as fifths rather than tenths. in other words .50
would
equal 1 not 1/2.

Sorry for the confusion.

"MartinW" wrote:


Hi M.A.

Your question is rather unclear,

=24.5-24.2 = 0.3 (yes that's right)

=20.4+0.1 = 20.5
=round(20.4+0.1,0) = 21

What are the fifths that you are talking about?

Regards
Martin


"M.A.Tyler" <Great Lakes State wrote in message
...

Is it possible to perform simple addition and subtraction in
fifths?
something like 24.5 - 24.2=.3,
or
20.4 + 0.1=21

Thanks.

M.A.Tyler