# multiple if statments

1. ## multiple if statments

Hi
In the yellow column of the attached I need a formula the returns the following "On Time" or "Overdue" using the following information: If the date in column D is greater that the date in column B then "Overdue" if not return "On Time". However if there is no date in the column D cell then if Todays date is greater than the date in column B return "Overdue" if not return On "Time"

Thanks

2. ## Re: multiple if statments

Hi

Try in C2

=IF(AND(D2="";B2<TODAY());"OVERDUE";IF(D2>B2;"OVERDUE";"ON TIME"))

Hope to helps you.

3. ## Re: multiple if statments

Maybe:

=IF(IF(D2<>"",INT(D2),INT(TODAY()))>INT(B2),"Overdue","OnTime")

Regards, TMS

4. ## Re: multiple if statments

Brilliant thank you very much. I was wondering how does that formula work?

Which one?

6. ## Re: multiple if statments

Sorry the one you gave me.

7. ## Re: multiple if statments

=IF(IF(D2<>"",INT(D2),INT(TODAY()))>INT(B2),"Overdue","OnTime")

INT(B2) and INT(D2) take the integer part of the date/time in the celsl so that the time does not confuse the issue ... unless you want it to? Then, in both cases you are comparing just the date and not the time.

IF(D2<>"",INT(D2),INT(TODAY()) ... this checks if D2 is blank; if it's not, it uses INT(D2) in the comparison; if it is, it uses TODAY() in the comparison

And then it's just a straightforward comparison; is one date greater than the other.

I hope that makes sense.

Regards, TMS

8. ## Re: multiple if statments

@TMS.

This is a dublicate post!!!

9. ## Re: multiple if statments

@Fotis: not sure what you mean. My original response did double post (good old forum software) but I deleted the second copy. The most recen response stared by stating the original formula and breaking it down.

Are you saying that the whole thread is a duplicate?

Right now, I'm not that fussed

10. ## Re: multiple if statments

@ Tms.

I DID JUST a joke. your Original response did double post but YOU deleted the second copy.

I saw it, BEFORE, you delete and made this joke, for the usual forum problems...

11. ## Re: multiple if statments

@Fotis: sorry, the whole thing is a bit of a joke at the moment so it's difficult to know what to take seriously

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1