| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| tenths to fifths | Excel Discussion (Misc queries) | |||
| IRR calculations | Excel Discussion (Misc queries) | |||
| Calculations | Excel Discussion (Misc queries) | |||
| Calculations | Excel Discussion (Misc queries) | |||
| if calculations | Excel Worksheet Functions | |||
Linear Mode
