Hide #VALUE! in a cell

the formula below enters the #VALUE! if any of AD411, Y411 or AA411 have no value entered in them. Is there a way of hiding the # VALUE in the cell, or incorporating a hide mechanism within the formula. Apart from this little hiccup the formula does what it's meant to do.

=IF(M411="","-",IF(OR(P411="e",M411="e",AD411="e",Y411="e",AA411="e",),"ELIM",(IF(OR(M411="s"),"SCR",(IF(OR(AD411="w",Y411="w",AA411="W",),"W/D",(IF(OR(AD411="r",Y411="r",AA411="r"),"RET",SUM(AD411+Y411+AA411)))))))))

I'm pretty new to excel and am self taught, this one is giving me a hard time.
Any help would be greatly appreciated.

Try to integrate the function ISNUMBER (or ISERROR) into the formula:

Please Login or Register  to view this content.

My excel is in danish, so you might need to change some of the ; to , or the other way around.
But the idea is:

Please Login or Register  to view this content.

Hello,

with Excel 2010 you can use IFERROR()

=Iferror(yourformula,errormessage)

For example, if you want to return an empty cell if the formula errors, then use

Please Login or Register  to view this content.

cheers,