How do I create a spread sheet w/a numerator/denomenator?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Enter numerator in B3 ---> 2
Enter denominator in C3 ---> 3
D3 =B3&"/"&C3 << Displays 2/3
 
I need to have the numerators and denom add separately to maintain the total
numbers of both.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Monthly Spread sheet. 12
Formatting rows in a spread sheet. 8
Printing from side by side spread sheets 1
How do I embed a word doument in an excel spread sheet? 1
who creat this spread sheet? 1
Computor would not save spread sheet and lost my unsaved work 1
How do I spread numbers over several months? 3
Spread sheet numbering 4

Back
Top