1

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?

Improve this question

1 Answer 1

Reset to default
3

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)
Improve this answer
2
  • 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, 2012 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, 2012 at 19:52

You must log in to answer this question.

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