Solved

how to do percentages in iwork numbers

Posted on 2011-09-13
4
409 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36532608
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
ID: 36532619
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
ID: 36532629
thanks for your help!
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 36532643
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

631 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