make tax calculation only to two decimal

[aimee_quaife]

I have an excel document for some basic accounting. It calculates the state and county tax for book sales, then adds this to create a total. I need it to just have two decimal places (which it displays), but when it does the final sum, it uses more then two decimals in the calculation but just shows two. For example:

A1 (Subtotal) =$24.65,
B1(State tax E3/100*5) = $1.23,
C1 (County Tax E3/100*0.5) = $0.12,
D1 (Total SUM(E3:H3)) = $26.01

So there is an extra 1c that shouldn't be there if the tax only calculated to two decimals.

If anyone can help me resolve this I'd really appreciate it!

 

[pagrender]

Hi,

It looks like your formulas in B1 & C1 should be rounded to two digits:

B1: =ROUND(E3/100*5,2)
C1: =ROUND(E3/100*0.5,2)

 

[pagrender]

I forgot I downloaded Excel Jenie... so I can show the results:
Sheet1

<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"><COL style="WIDTH: 64px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="TEXT-ALIGN: right"> 24.6500 </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">1.2300 </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="TEXT-ALIGN: right; FONT-FAMILY: Verdana; FONT-SIZE: 10pt">0.1200 </TD><TD> </TD><TD> </TD><TD> </TD><TD style="TEXT-ALIGN: right">24.65</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="TEXT-ALIGN: right"> 26.0000 </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR></TBODY></TABLE>
<TABLE style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border=1 cellSpacing=0 cellPadding=2><TBODY><TR style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>A2</TD><TD>=ROUND(E3/100*5,2)</TD></TR><TR><TD>A3</TD><TD>=ROUND(E3/100*0.5,2)</TD></TR><TR><TD>E3</TD><TD>=A1</TD></TR><TR><TD>A4</TD><TD>=SUM(A1:A3)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

 

[aimee_quaife]

thank you so much!! that works perfectly