<tbody> </tbody> |
<tbody> </tbody> |
Excel 2007 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
13 | Input 1 | Input 2 | Format %age | Format Fraction | Result?? | ||
14 | 239 | 326 | 73% | 239/326 | 239/326 (73%) | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D14 | =B14/C14 | |
E14 | =B14/C14 | |
F14 | =TEXT(B14/C14, "???/???")&" ("&TEXT(B14/C14, "0%")&")" |
Excel 2010 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | 236/329 | 236/329 (72%) | ||||
2 | 236 | 329 | 236/329 (72%) | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1 | =A1&" ("&ROUND(236/329,2)*100&"%)" | |
D2 | =A2&"/"&B2&" ("&ROUND(A2/B2,2)*100&"%)" |