• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Use of IS ERROR IN IF function to returns result

D

dsb1985

New Member
Problem = I have a Fix AR Date in one cell and also have due date of invoices, in Due date column some cells have #n/a error. By use of IF(ISERROR) function i want if cells have any error then it returns Due, if AR Date is less than equal to due date (< or =)then it returns Due otherwise Not Due


Please help me.....


AR DATE = 21/06/2013

Due Date

#n/a

#n/a

20/06/2013

25/06/2013
 
Dsb1985


Firstly, Welcome to the Chandoo.org Forums


Try: =IF(IFERROR($B$1<=A3,TRUE),"Due","Not Due")

copy down

Refer: https://www.dropbox.com/s/ass0ag872juea74/dsb1985.xlsx
 
You must log in or register to reply here.
Back
Top