IF formula problems....

[Rosco88]

Morning All,

I have an IF formula, and it does not seem to work, not sure if I've messed up somewhere along the line.

I have attached a sample spreadsheet of what I am working on, but haven't a clue how to proceed.

TEST4.xlsx

What I need is in Column P to show today's date if the date in Column J is either today's date, or before today's date.

But, if Column H ha the words "PROFORMA" "TBC" or "YES" in the cells i need the box in column P to be blank.

This is the formula i have currently:

Please Login or Register  to view this content.

Hopefully this makes sense.

Thanks in advance.

Ross

[Pepe Le Mokko]

Does this help ? =IF(OR(H3="proforma";H3="TBC";H3="YES");"";IF(J3<=TODAY();TODAY();""))

(Replace semi colons with commas)

[Rosco88]

Thanks Pepe, But this is only bringing the date up in Column P against the Column H's "YES"

[Rosco88]

Quick Bump, Is anyone able to assist?

Thanks
Ross

[Pete_UK]

Put this in P2:

=IF(OR(H2="PROFORMA",H2="TBC",H2="YES",J2=""),"",IF(OR(H2="DUE",J2<TODAY()),TODAY(),J2))

then copy down.

Hope this helps.

Pete

[Rosco88]

Pete_UK,

Thanks alot!! Exactly what I needed!!

Many Thanks
Ross

[Pete_UK]

Glad to help.

If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

Also, you might like to click on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete