Cells Formula (Need Help)

[agonysWeeper]

A1 = 18
B1 = 1,700
C1 = must be calculate A1 * B1 so equal to 30, 600 but I need to add 10% from the 30, 600 and I want C1 will show up 34, 000.

Please help. thanks

 

[repairman615]

Hello,

Try these:


<TABLE style="WIDTH: 188pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=250><COLGROUP><COL style="WIDTH: 188pt; mso-width-source: userset; mso-width-alt: 4571" width=250><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; WIDTH: 188pt; HEIGHT: 15pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20 width=250>=(A1*B1)*(1+0.1)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #eaf1dd; HEIGHT: 15pt; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl65 height=20>=ROUND((A1*B1)*(1+0.1),-3)</TD></TR></TBODY></TABLE>

 

[Ruddles]

Or:-

=A1*B1*(10/9)