Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

shuffles

macrumors 6502
Original poster
Nov 7, 2007
403
8
dublin, ireland
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.
 
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.
 
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.

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
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.