Round Total
 

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 Total
 

=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




"Rao Ratan Singh" wrote in message
...
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 Total
 

=ROUND((C9*$C$8+D9*$D$8+E9*$E$8)/100,0)
--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rao Ratan Singh" wrote in message
...
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?

Thank you
 

Thank u bob and peo. It's working.

Rao Ratan Singh