use
=IF(*MOD(ROUNDUP(C2*3%+C2,-1),10)>5*,*
ROUNDUP(C2*3%+C2,-1)-MOD(ROUNDUP(C2*3%+C2,-1),10)+10*,*
ROUNDUP(C2*3%+C2,-1)-MOD(ROUNDUP(C2*3%+C2,-1),10*))
On Fri, Sep 24, 2010 at 9:12 AM, sudarshan rampe wrote:
> hi swapnil...
> if i am using round formula then the resultant value is coming to nea
hi swapnil...
if i am using round formula then the resultant value is coming to nearest
ten. but i need the resultant value to next ten only if the value is more
than 1 rupee in the one's place.
Eg
for ---8350-00
result8600.50
in this case only 8600 should be displayed.
but
for---9460
res
Hi,
Instead of "Roundup" try "Round" formula.
Regards,
Swapnil
On Thu, Sep 23, 2010 at 3:49 PM, sudarshan rampe wrote:
>
> hi friends hereby i am attaching a worksheet in which i need a addition in
> the given formula for getting the desired result.
> please help me out.
> --
> Sidhu
>
> --
>
hi friends hereby i am attaching a worksheet in which i need a addition in
the given formula for getting the desired result.
please help me out.
--
Sidhu
--
--
Some important links for excel users:
1. Follow us on TW