Calculations in fifths?
 

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

Calculations in fifths?
 

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

Calculations in fifths?
 

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

Calculations in fifths?
 

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)




"M.A.Tyler" <Great Lakes State wrote in message
...
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

Calculations in fifths?
 

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

Calculations in fifths?
 

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

Calculations in fifths?
 

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

Calculations in fifths?
 

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

Calculations in fifths?
 

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

Calculations in fifths?
 

Then David Biddulph's reply will do what you want.

M.A.Tyler wrote:

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