Calculation problem to produce 3 different results from IF

**mgxeab** · 09-16-2013, 03:52 AM

I have a column called Receipt date, a column called Task due date

I have created a column called On time Yes/No. I need to calculate according to the Receipt date and Task due date to see whether the task was completed on time or not, this worked well with:

=IF(Receipt date>Task due date,"No",IF(Receipt date<Task due date,"Yes"))

However, if the Receipt date is blank, it defaults to a Yes result - which I do not want. How can I get the column to display something like "NA" if Receipt date is blank?

**Fotis1991** · 09-16-2013, 03:56 AM

Perhaps something like this?

=IF(Receipt date="","",IF(Receipt date>Task due date,"No",IF(Receipt date<Task due date,"Yes")))

**mgxeab** · 09-16-2013, 04:08 AM

Brilliant! Thank you so much that worked, I did something similar but put that first part at the end instead of the beginning - not sure why that would make a difference? Or maybe I missed a smalll thing.

Great thanks!

**Fotis1991** · 09-16-2013, 04:11 AM

This should be the first condition in you formula!

So..

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.