IF & MROUND

[phuser]

=IF(ISERROR(F151-L151),"",IF(SUM(F151-L151<=0),"-",MROUND((F151-L151),10)))


if there are numbers in either cells I get a #NAME Error, what am I missing?

[Peo Sjoblom]

make sure analysis toolpak is installed, mround is not a native excel
function although it comes with excel, so tools>add-ins and select analysis
toolpak and if necessary keep the cd handy

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"phuser" <[email protected]> wrote in message
news:[email protected]...
> =IF(ISERROR(F151-L151),"",IF(SUM(F151-L151<=0),"-",MROUND((F151-L151),10)))
>
>
> if there are numbers in either cells I get a #NAME Error, what am I
> missing?
>
>

[daddylonglegs]

You don't need MROUND if you're rounding to the nearest 10

=ROUND(A1,-1) does the same as

=MROUND(A1,10)

so change your formula to

=IF(ISERROR(F151-L151),"",IF(L151>=F151,"-",ROUND(F151-L151,-1)))

[phuser]

thanks so much daddy, worked like a charm

"daddylonglegs" <[email protected]>
wrote in message
news:[email protected]...
>
> You don't need MROUND if you're rounding to the nearest 10
>
> =ROUND(A1,-1) does the same as
>
> =MROUND(A1,10)
>
> so change your formula to
>
> =IF(ISERROR(F151-L151),"",IF(L151>=F151,"-",ROUND(F151-L151,-1)))
>
>
> --
> daddylonglegs
> ------------------------------------------------------------------------
> daddylonglegs's Profile:
> http://www.excelforum.com/member.php...o&userid=30486
> View this thread: http://www.excelforum.com/showthread...hreadid=555802
>