#VALUE Help

  • Thread starter Thread starter MrSales
  • Start date Start date
M

MrSales

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,
 
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
=================================
 
=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Largest value in column A based on conditions in columns B and C 6
Vlookup returning #n/a 2
AVERAGE Row of Numbers and Return Corresponding Numeric Label 14
LOOKUP formula 4
Hlookup, range_lookup parameter 1
prob in IF then else statement 1
Count entries in columns and rows 3
SUM formula after HLOOKUP result true 9

Back
Top