Hi all,
I m using this function =ROUND(C9*$C$8 D9*$D$8 E9*$E$8,0)/100 but it is
returning sum 53604.62
I want its result should be 53605.00
How?
=ROUND((C9*$C$8 D9*$D$8 E9*$E$8)/100,0)
maybe
--
Regards,
Peo Sjoblom
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email address)
Portland, Oregon
quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Hi all,
gt; I m using this function =ROUND(C9*$C$8 D9*$D$8 E9*$E$8,0)/100 but it is
gt; returning sum 53604.62
gt;
gt; I want its result should be 53605.00
gt;
gt; How?=ROUND((C9*$C$8 D9*$D$8 E9*$E$8)/100,0)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Hi all,
gt; I m using this function =ROUND(C9*$C$8 D9*$D$8 E9*$E$8,0)/100 but it is
gt; returning sum 53604.62
gt;
gt; I want its result should be 53605.00
gt;
gt; How?
Thank u bob and peo. It's working.
Rao Ratan Singh
- Jan 24 Wed 2007 20:35
Round Total
close
全站熱搜
留言列表
發表留言