I have a formula created and as a result of the functions it must go
through it may return #VALUE. How can I get it to show nothing instead
of #VALUE?

E21==IF(ISNA(HLOOKUP(A21,Sheet1!A155:G157,3,TRUE)) ,"",HLOOKUP(A21,Sheet1!A155:G157,3,TRUE))

As a result it's returning blank because A21 is blank

M21==ROUNDUP(E21,3) Returns #VALUE

Thank You,


--
MrSales
------------------------------------------------------------------------
MrSales's Profile: http://www.excelforum.com/member.php...o&userid=32572
View this thread: http://www.excelforum.com/showthread...hreadid=528276