How to replace #VALUE with nothing

[esmatullaharifi]

Hi dears!
I use DGET formula in my Data Table. When it empty in DGET Value appears #VALUE. How i can change this error message to blank cell without removing formula.

[alansidman]

Combine an =If Statement with an IsError Statement.
Something like this

=if(iserror(your DGET function)=TRUE,"",Your DGET function)

[jeffreybrown]

Maybe even...

=IFERROR(DGET(database,field,criteria),"")

...since your profile shows 2012

[esmatullaharifi]

Thanks Dear jeffreybrown for your Answer. I find my way.

[esmatullaharifi]

Hi Dears!
How i can post new thread. I am not able to post new thread. Please help me.

[jeffreybrown]

Try...

http://www.excelforum.com/faq.php?fa...eading_posting

[esmatullaharifi]

Hi Dears!
I want to learn how i can able to do a function or ... to LOCK a Cell automatically after editing and no one able to edit it again without entering Password.

[jeffreybrown]

@esmatullaharifi,

If you have another question please post in its own thread.

[esmatullaharifi]

How i can Post a new thread plz?

[esmatullaharifi]

Dear jeffreybrown!
I can't post new thread. Please post this Question for me. And send me the URL of this new thread and i will subscribed. Please. My Question is (I want to learn how i can able to do a function or ... to LOCK a Cell automatically after editing and no one able to edit it again without entering Password.)

[alansidman]

For information on how to use the forum please follow one of the links to our how to sections or frequently asked questions!
Navigation bar including the How to...? dropdown
How to videos
Frequently asked questions