Skip navigation

how can i work out say 5% of 383.04

233 Views 4 Replies Latest reply: Apr 18, 2013 11:36 AM by Jerrold Green1 RSS
LavinaL Level 1 Level 1 (0 points)
Currently Being Moderated
Apr 18, 2013 5:55 AM

I am trying to work out a percentage of a number. Say for eg cell A1 is 5% and cell A2 is 383,04. The cell gives me an error - a red triangle saying "the operator * expects a number, but cell A2 contains a string. I changed the comma for a fullstop on 383.04 and it gave me the correct answer. What i wanted to know is how can i customise the 383.04 cell so that it also accepts a comma for the calculation - 383,04. Thanks!!!

MacBook Pro
  • Wayne Contello Level 6 Level 6 (12,580 points)
    Currently Being Moderated
    Apr 18, 2013 6:10 AM (in response to LavinaL)

    5% is the same as 5/100 which equals 0.05.  So to compute 5% of a value you:

     

    perform the operation:

      0.05*value   or

    5*value /100

     

    Screen Shot 2013-04-18 at 8.10.15 AM.png

    B4=B3*B2/100

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Apr 18, 2013 7:52 AM (in response to LavinaL)

    LavinaL wrote:

     

    I am trying to work out a percentage of a number. Say for eg cell A1 is 5% and cell A2 is 383,04. The cell gives me an error - a red triangle saying "the operator * expects a number, but cell A2 contains a string. I changed the comma for a fullstop on 383.04 and it gave me the correct answer. What i wanted to know is how can i customise the 383.04 cell so that it also accepts a comma for the calculation - 383,04. Thanks!!!

    Lavina,

     

    The decimal separator depends on your system language choice, or your application language choice if you are using Language Switcher. It's not something that is optional within the normal programming parameters. If this issue is critical to your document, it could be accomodated with an expression in the result cell.

     

    How big a deal is this for you?

     

    Here's an example on a system expecting a period for a decimal separator.

     

    Screen Shot 2013-04-18 at 10.49.44 am.png

     

    To go the other way, you would exchange the comma and the period in the illustrated formula. As written, the result will calculate with either decimal seaprator.

     

    Jerry

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Apr 18, 2013 11:36 AM (in response to LavinaL)

    You're welcome. If you have any trouble getting it to work, let us know.

     

    Jerry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.