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