how to do percentages in iwork numbers

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!
only1wizardAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
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
 
only1wizardAuthor Commented:
i will give that a shot but i always used 27.95-45% and would get the answer will post results.
0
 
only1wizardAuthor Commented:
thanks for your help!
0
 
barry houdiniCommented:
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
All Courses

From novice to tech pro — start learning today.