close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()