Display a Result in Percent and Division

EmilyEchevarria

Hello,

I currently have a sheet that counts a quantity of total on time (YTD) and total overall, referenced from another sheet. And then I have another column that takes this two values to give me a percentage. I have a table that shows me the percentage based per month, you can see it the upper table), the second table is an example of what I'm trying to make, which show the percentage and the fraction (which I did t manually), is there a way to make the first table look like the second table without entering the data manually?

markkrebs

=[formula 1] +char(10) + "("+[formula2]+")"

should get you close. if formula's are looks to other sheets then use index(Match) formula