Rounding calculation to ONLY two deci places

M

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?
 
M

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)
 
D

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)
 
Top