• 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.

Help with IF formula

I have two columns containing dates.
I'm trying to write a formula in a third column returning an X if the date in B is larger than the date in A. If date A is bigger or like B i want the cell to be blank.
IF A1=B1 leave blank
IF A1>B1 leave blank
If A1<B1 return an X
 
I have two columns containing dates.
I'm trying to write a formula in a third column returning an X if the date in B is larger than the date in A. If date A is bigger or like B i want the cell to be blank.
IF A1=B1 leave blank
IF A1>B1 leave blank
If A1<B1 return an X

Hey Please see attached and let me know if it is exactly what you wanted.

Gift
 

Attachments

  • Book1.xlsx
    8.4 KB · Views: 10
Back
Top