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

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

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

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

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

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

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

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