Excel_user_MM
New member
- Joined
- Aug 27, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
How do I get the latter sum of this formula to return the value in percentage, not as a decimal number:
="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&((SUM(AT2:AT260)/(SUM(AS2:AS260))))
I.e. as result I would want:
No of girls: 3 / % girls: 43 %
NOT
No of girls: 3 / % girls:0.428571428571429
Is it even possible?
Thanks folks!
="No of girls: "&(SUM(AT2:AT260))&" / % girls:"&((SUM(AT2:AT260)/(SUM(AS2:AS260))))
I.e. as result I would want:
No of girls: 3 / % girls: 43 %
NOT
No of girls: 3 / % girls:0.428571428571429
Is it even possible?
Thanks folks!