Thread: Round Up/Down ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TQ TQ is offline
external usenet poster
 
Posts: 46
Default Round Up/Down ?

Hi,question as below

B2=3.6 C2=2440 D2=1220 E2=1700 G2=$667.00

F2=18.2180(from formula=B2/1000*C2/1000*D2/1000*E2)

I get the figure $12,151.42 from G2*F2.According to calculator $667.00 *
18.2180 should get $12,151.41. Is that any solution to solve the different ?I
want it get exactly same with calculator and using by formula to get F2
figure.

Thanks !