Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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:

=(G9*$G$1)

to

=ROUND(G9*$G$1, 2)
share|improve this answer
1  
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

 
discard

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.