| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
