Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am doing a formula that takes a cost x a mark up % to get a sell price.

$11.47 x 1.35 = $15.48. I then need to go and copy and paste values to remove the mark up for my customers. When I do this, it gives me $15.4845 which throws off my lot dollars. Is there anyway to mark this to only calculate to 2 decimal places?

share|improve this question

Change the number format of the cells to $0.00 or in your formula use the worksheet function ROUND(number, decimal places).

So your formula would change from:



=ROUND(G9*$G$1, 2)
share|improve this answer
The first option will change the way the number looks without changing the value, the second will change the actual value. – nutsch Nov 6 '12 at 1:00
Where in my formula would I put the function? Here is what my formula looks like: (G9*$G$1) – Nicki Nov 9 '12 at 19:52
THANK YOU SO MUCH!!!! – Nicki Nov 12 '12 at 17:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.