Tuesday, November 2, 2010

I'm back for good! What is IsError Function?

Did not realize it will took sometime to get me going on this blog but I'm back now and will stay for good!

On the previous post some time ago...you've learned about Vlookup function, Iserror function is here to give you a more appropriate result, because if vlookup didn't find any value it will show an error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME? or #NULL) to solve this you will have to replace it with zero or a text ("not found", "unpaid").

Microsoft Excel,Spreadsheet,Excel Formula,IsError

Returning to previous post about Vlookup, this will be the final cell formula: Add IF function before the Iserror function:

=IF(ISERROR(VLOOKUP(Invoice_number,[range]Invoice_number-amount_paid,2,FALSE)),"not yet paid",(VLOOKUP(Invoice_number,[range]Invoice_number-amount_paid,2,FALSE)))

No comments: