Calculations in fifths?

M

M.A.Tyler

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
 
M

MartinW

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

M.A.Tyler

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.
 
C

Chip Pearson

Take a look at the DOLLARDE and DOLLARFR functions. These are part of the
Analysis ToolPak add-in, so this must be loaded. (In Excel, Tools menu,
Add-Ins item, check "Analysis ToolPak" in the list.) For example, if A1 =
0.4 and B1 = 0.1, the function

=DOLLARDE(A1,5)+DOLLARDE(B1,5)

returns 1.

See also http://www.cpearson.com/Excel/fractional.htm.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting LLC
www.cpearson.com
(email on the web site)
 
B

Bob I

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

MartinW

Hi MA,

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

HTH
Martin
 
M

M.A.Tyler

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.
 
D

David Biddulph

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.
 
Top