LinkBack URL
About LinkBacks
Hello
i have this formula :
=IF(ISBLANK(A7),"",VLOOKUP(A7,PaperCode!A3:C23,2,FALSE))
and
=IF(ISBLANK(A7),"",C7*D7)
How can i include ISERROR?
Kindly guide me.
Thanks in Advance.
Hello
i have this formula :
=IF(ISBLANK(A7),"",VLOOKUP(A7,PaperCode!A3:C23,2,FALSE))
and
=IF(ISBLANK(A7),"",C7*D7)
How can i include ISERROR?
Kindly guide me.
Thanks in Advance.
Last edited by maharaskal; 12-02-2011 at 03:26 AM.
Try this instead:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hello Again Maharaskal,
Just for ideas.
Errors:
#N/A (with ISNA)
#Value (with ISERROR)
blank (with ISBLANK)
In your formula you used isblank to test if A7 is blank
you use iserror if your receiving a #value, --this will give you true or false
If you cannot found the data the error will be #N/A you use ISNA.
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Originally Posted by vlady
Hello Again Maharaskal,
Just for ideas.
Errors:
#N/A (with ISNA)
#Value (with ISERROR)
blank (with ISBLANK)
In your formula you used isblank to test if A7 is blank
you use iserror if your receiving a #value, --this will give you true or false
If you cannot found the data the error will be #N/A you use ISNA.
Ho can i combine the with iferror for the below formula?
=IF(ISBLANK(A8),"",C8*D8)
Don't quote whole posts -- it's just clutter.
If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
Sorry, i wont repeat the mistake again.
How about:
=IF(OR(ISBLANK(A8),ISERROR(A8)),"",C8*D8)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks