percentage
Hi Briggs,
You could code the formula field as:
{=(1-(B1/A1))*100 \# 0.00%}
where the Regular Price is in A1 and the Sale Price is in B1.
Note: The field brace pair (ie '{ }') for the above example is created via Ctrl-F9 - you can't simply type them or copy & paste them
from this message.
--
Cheers
macropod
[MVP - Microsoft Word]
"Briggs" wrote in message ...
I'm trying to create a table that will calculate what percentage something
increased. For example, the regular price is in cell A and the sale price is
in cell B. How can I find the percent discount using the formula function in
tables?
--
Briggs
|