Solve : Excel Formula Show Percentage?

1.	Solve : Excel Formula Show Percentage?
Answer» I'm trying to create a FORMULA that gives the result of the number of cells in a row that contain text. For example if I have four cells in a row and three contain text the result WOULD be 75%, if I have seven cells in a row and four have text the result would be 57%. This is what I have so FAR... =COUNTA(B9:H9)/COUNTA(B9:H9)=COUNTA(B9:H9)/COLUMNS(B9:H9) Format CELL as percentage; select number of decimal places.

Discussion