Solved

how to do percentages in iwork numbers

Posted on 2011-09-13
4
391 Views
Last Modified: 2012-06-21
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:

$27.95 - 45% = answer

thanks in advance for your help!
0
Comment
Question by:only1wizard
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
Comment Utility
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

by:only1wizard
Comment Utility
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

by:only1wizard
Comment Utility
thanks for your help!
0
 
LVL 50

Expert Comment

by:barry houdini
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

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.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now