Rounding calculation to ONLY two deci places

[Mustang]

I have a simple calculation in a workbook for sales taxes. I need the
answer to the calculation to be rounded to only two decimal places.
Right now I have the -visibile- number to be two places, but the "real"
number (i.e. if you Paste Special'd the cell) has an infinite number of
decimal places. This screws up a 2nd calculation I have, as it says
there's a variance when there really isn't...

Any ideas on how to make the "behind the scenes" number round to only
two places?

 

[Don Guillett]

=round(a2,2) won't do?

 

[Mustang]

That's perfect! Now I have to play with the IF statement to see if I
can incorporate that instead of having another column... Any ideas,
while I'm looking at it too? This is what's in the cell already:

=IF(L20="",I20*0.06,I20*0.07)

 

[Dave Peterson]

One way:

=IF(L20="",ROUND(I20*0.06,2),ROUND(I20*0.07,2))

or

=ROUND(I20*IF(L20="",0.06,0.07),2)

 

[Don Guillett]

maybe?
=ROUND(120*IF(L20="",0.06,0.07),2)

 

[Mustang]

You guys are the best... I've been frustrated by this for 4 months!
Thanks!