percentage

B

Briggs

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?
 
M

macropod

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.
 
B

Briggs

Thank you. I entered that forumla, but all I get is the actual text of the
formula. It doesn't calculate anything. I'll try again!
--
Briggs


macropod said:
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 said:
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?
 
S

Suzanne S. Barnhill

Did you use Table | Formula or Ctrl+F9 to create the field? Did you then
toggle and update the field (Alt+F9, F9)?

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org

Briggs said:
Thank you. I entered that forumla, but all I get is the actual text of
the
formula. It doesn't calculate anything. I'll try again!
--
Briggs


macropod said:
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 said:
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top