MrExcel Publishing
Your One Stop for Excel Tips & Solutions

round problem

Posted by suzanne on December 20, 2001 11:49 PM

I have to calculate for d5(cost per piece) =(f5/5/3): f5 being the price per pece in another currency: e5=b5(quantity)* d5 to get the total value. I find that after the calculation if D5 show $0.60, and B5 has 200 pcs, instead of giving the value $120, it will give a lower figure, because I think the value used in d5 is not rounded off and probably the unrounded value is used i.e. $0.59872, is there a way I can get the value in D5 rounded so that the final value in E5 gives a correct result.??

Posted by Bruno on December 21, 2001 12:03 AM

use :
e5=b5* round(d5,2)



Posted by suzanne on December 21, 2001 2:00 AM