Solved

# how to do percentages in iwork numbers

Posted on 2011-09-13
391 Views
hello -

i can do percentages in excel but when i try to do it in numbers it doesnt reconize it.

heres what im trying to do example:

0
Question by:only1wizard
• 2
• 2

LVL 50

Accepted Solution

barry houdini earned 500 total points
What do you expect the answer to be? If you want to subtract 45% of the value of 27.95 from 27.95 then in Excel that would be

=27.95*(1-0.45)

to give 15.37

I imagine that'll work in iwork too

regards, barry
0

Author Comment

i will give that a shot but i always used 27.95-45% and would get the answer will post results.
0

Author Closing Comment

0

LVL 50

Expert Comment

If you use

=27.95-45%

In excel  then that treats 45% like 0.45 and the answer you get is 27.5, I assume that isn't the expected result....or is it?

barry
0

## Featured Post

Yesterday Apple introduced their revolutionary new iOS 5 operating system that claims to be the ultimate mobile technology interface. One of the biggest innovations of the new operating system is the introduction of the iCloud computing network. Thi…
A lot of new and distinct gadgets are making their appearance every other day. The latest gadget that has wooed the attention of all gadget lovers and non gadget lovers alike is the Smartwatch. This tiny gadget is capable of offering live access to …
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.