=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" <RaoRatanSingh@discussions.microsoft.com> wrote in message
news:A54C2FF2-EC5A-4434-819F-7E4E4DF3A82B@microsoft.com...
> 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?
Bookmarks