Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
I'm trying to create a percentage formula in my table. I want D9 to show 20% of D8. So I'm typing =D8*20% but the asterisk keeps changing itself into an x and giving me some crazy number. Any ideas why?
iMac, iOS 7.1
try:
=SUM(D8*20%)
Peter
Or ...
=PRODUCT(D8, 20%)
T,
The two things are not related. iWork '13 changes the asterisk to a little "x" character that stands for the multiply operator, not the same code as for a lower case X, but it looks a lot like one. Also, a slash character that we normally associate with division is changed into the divide symbol, ÷. (A dash with dots above and below.)
This was all just a waste of time on the part of the programmers, in my opinion, and a source of confusion for us.
That business has nothing to do with why you are having trouble multplying the contents of D8 by 20%. What is the content of D8? What exactly is your result?
Jerry
My asterisk keeps changing to a x
