How to manually piece together a fraction on excel

0 votes

I want to manually construct a fraction that could be read using conditional formatting while working with some tallies.

Following is the extracted formula that use fractional values:

COUNTIFS(Converter!40:40,"Y",Converter!$5:$5,F$5) & " / " & COUNTIFS(Converter!40:40,"Y",Converter!$5:$5,F$5) + COUNTIFS(Converter!40:40,"N",Converter!$5:$5,F$5)

Basically, the percentage should look like a/(a+b), and I want all tabulated digits, such 2/8 or 20/100, to be displayed when appropriate. Unfortunately, Excel is only seeing this as a date; even after using the TEXT() formula, Excel still interprets the digits as dates.

The conditional formatting should turn red for any number less than "1" if possible. How am I supposed to get Excel to read the numbers as fractions? It would be highly appreciated if you could help!

Oct 28 in Others by Kithuzzz
• 20,660 points
32 views

1 answer to this question.

0 votes

Instead of controlling formatting in your calculations, you should leave it up to how it appears visually.

You must first choose the cell that you want to format as a fraction.

enter image description here

Then you choose the desired fraction quantities.

Edit: You must use a custom format if you want to fix the denominator.

enter image description here

answered Oct 28 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How to import data from a HTML table on a website to excel?

Hello  To import any HTML file in excel there ...READ MORE

answered Feb 10 in Others by gaurav
• 22,040 points
307 views
0 votes
2 answers

How to copy a formula horizontally within a table using Excel VBA?

Hi so basically, create an adjacent column ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
207 views
0 votes
1 answer

How to install a GUI on Amazon AWS EC2 or EMR with the Amazon AMI

The top-level script for installing the GUI ...READ MORE

answered Mar 9 in Others by gaurav
• 22,040 points
101 views
0 votes
1 answer
0 votes
1 answer

Excel COUNTIF formula

Please see MS Excel: COUNTIF Function (WS) You should ...READ MORE

answered Sep 29 in Others by narikkadan
• 37,660 points
60 views
0 votes
1 answer

Is there a maximum number of formula fields allowed in Excel (2010)

See http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx for limits on specs it doesn't indicate ...READ MORE

answered Sep 30 in Others by narikkadan
• 37,660 points
55 views
0 votes
1 answer

Multiplying cells and sum then for a range

Use SUM() as an Array formula:  =SUM(IFERROR((AB22:AB1100 = ...READ MORE

answered Oct 2 in Others by narikkadan
• 37,660 points
67 views
0 votes
1 answer

INDEX formula in Excel, Top 10, repeats previous value

Try this formula in cell W4: =IF(V3=V4,INDEX(INDIRECT("I"&MATCH(W3,I:I,0)+1&":I26"),MATCH(V4,INDIRECT("R"&MATCH(W3,I:I,0)+1&":R26"),0)),INDEX($I$2:$I$26,MATCH(V4,$R$2:$R$26,0))) The calculation ...READ MORE

answered Oct 8 in Others by narikkadan
• 37,660 points
59 views
0 votes
1 answer
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25 in Others by narikkadan
• 37,660 points
68 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP