Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .