Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create a spread sheet w/a numerator/denomenator?
I am creating a spread sheet that has different numerators and denomenators
for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3 is positive) however it is then converted into simpler terms loosing the denomenator feature. Such as 2/4 is then changed to 1/2 so I lose the accuracy of the denomenator. Any ideas of how I can keep the integrity of both the numerator totals and the denomenator totals? |
#2
|
|||
|
|||
Hi!
Why not just enter them as text? '2/3 '2/4 Biff "Denise" wrote in message ... I am creating a spread sheet that has different numerators and denomenators for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3 is positive) however it is then converted into simpler terms loosing the denomenator feature. Such as 2/4 is then changed to 1/2 so I lose the accuracy of the denomenator. Any ideas of how I can keep the integrity of both the numerator totals and the denomenator totals? |
#3
|
|||
|
|||
Enter numerator in B3 --- 2
Enter denominator in C3 --- 3 D3 =B3&"/"&C3 << Displays 2/3 "Biff" wrote in message ... Hi! Why not just enter them as text? '2/3 '2/4 Biff "Denise" wrote in message ... I am creating a spread sheet that has different numerators and denomenators for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3 is positive) however it is then converted into simpler terms loosing the denomenator feature. Such as 2/4 is then changed to 1/2 so I lose the accuracy of the denomenator. Any ideas of how I can keep the integrity of both the numerator totals and the denomenator totals? |
#4
|
|||
|
|||
I need to have the numerators and denom add separately to maintain the total
numbers of both. "Biff" wrote: Hi! Why not just enter them as text? '2/3 '2/4 Biff "Denise" wrote in message ... I am creating a spread sheet that has different numerators and denomenators for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3 is positive) however it is then converted into simpler terms loosing the denomenator feature. Such as 2/4 is then changed to 1/2 so I lose the accuracy of the denomenator. Any ideas of how I can keep the integrity of both the numerator totals and the denomenator totals? |
#5
|
|||
|
|||
Thank you, I will try that...
"Jim May" wrote: Enter numerator in B3 --- 2 Enter denominator in C3 --- 3 D3 =B3&"/"&C3 << Displays 2/3 "Biff" wrote in message ... Hi! Why not just enter them as text? '2/3 '2/4 Biff "Denise" wrote in message ... I am creating a spread sheet that has different numerators and denomenators for each data point. I was going to use "fractions" (i.e. 2/3 = 2 out of 3 is positive) however it is then converted into simpler terms loosing the denomenator feature. Such as 2/4 is then changed to 1/2 so I lose the accuracy of the denomenator. Any ideas of how I can keep the integrity of both the numerator totals and the denomenator totals? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I make a new spread sheet pop up, based on an entry in a c. | Excel Discussion (Misc queries) | |||
Excel window in spread sheet? | Excel Discussion (Misc queries) | |||
How do I create a command button to jump from sheet to sheet in a. | Excel Worksheet Functions | |||
how do i create an access code sheet to number my office files an. | New Users to Excel | |||
How do I create a total sheet that will pull info from all my she. | Excel Worksheet Functions |