Getting a Percent in Numbers?

Discussion in 'Mac Apps and Mac App Store' started by shuffles, Mar 8, 2010.

  1. shuffles macrumors 6502

    shuffles

    Joined:
    Nov 7, 2007
    Location:
    dublin, ireland
    #1
    I'm having trouble get percentages in numbers. I want to get 5% of one cell and display the answer in another. Whats the formula for this.
     
  2. shuffles thread starter macrumors 6502

    shuffles

    Joined:
    Nov 7, 2007
    Location:
    dublin, ireland
    #3
    Worked although 5% of €19.90 came out as 0.995. I want it to come out with less numbers after the decimal point as I will be adding up the 5% for a whole column to get the total. It's for eBay. The 5% is the final value fee eBay takes of the price and in this case the price is €19.90.
     
  3. miles01110 macrumors Core

    miles01110

    Joined:
    Jul 24, 2006
    Location:
    The Ivory Tower (I'm not coming down)
    #4
    I don't have Numbers so I can't tell you exactly how to do this, but there should be a button or an option to change how many decimal places are displayed. Look through the "Help."
     
  4. colourfastt macrumors 6502a

    colourfastt

    Joined:
    Apr 7, 2009
    #5
    If you're using Numbers .. on the toolbar at the top of the screen there are 2 buttons .. one with 2 decimal places going to the left and one with 1 decimal going to the right .... that's the one you would use to reduce the number of decimal places in the answer. FYI .. 5% of €19.90 is €1.00
     

Share This Page