Normal Text in Formula

E

exutable

Hey I was working on something and I cant figure out how to put normal
text into a formula, for example:
COUNTIF(A1:A5, "SOLD")/COUNTIF(B1:B5, "ITEM")
I want it to come out like this: 3/5 but of course it divides the two
numbers.... Anybody know?
 
A

Arvi Laanemets

Hi

The another option is to format the cell as Fraction - the the result
remains a number.
 
Top