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

 

[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]...