MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula's in Excel


Posted by Paul King on January 25, 2002 6:55 AM

How do I include a % in a formula

(eg) £17.50 x 17.5% x 12months

Tell me how to calculate the above


Posted by Dan Aragon on January 25, 2002 7:22 AM

Convert to a decimal. In your case .175
17.50 * .175 * 12

Is that what you mean?

Posted by Joe Was on January 25, 2002 8:16 AM

Dan is correct you do not use percent notation in a formula, you convert it to its decimal equivalent.

You can use a concantenated string to add a "%" to a result which is a percent as:

=(x/y)*100 & "%"

Hope this helps. JSW