#VALUE Help
 

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

#VALUE Help
 

Use thsi formula in M21:

=IF(E21="","",ROUNDUP(E21,3))

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
=================================
"MrSales" wrote in
message ...

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

#VALUE Help
 

=IF(ISERROR(ROUNDUP(E21,3)),"",ROUNDUP(E21,3)) will return a blank. The
#VALUE is the result of a faulty value in E21, eg text iso number.

"MrSales" wrote:


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