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
