IF and OR formula issue

[willisd]

Hi

I am trying to use this formula but it is not allowing me.

=if(or(AT2<DATE(2017,7,24),"settled",if(or(BE2<=DATE(2018,2,28),"settled","not settled"))

Any help much appreciated.
Thanks

 

[Aladin Akyurek]

Re: IF and OR forumal issue

Is till cant get this to work. The date in the cells that I am looking up is in this format mm/dd/yyyy.
I always want to return settled if cell AT2 is met. If the criteria is not met (ie the date is not less than 24 july), then I want cell BE2 to be assessed.

Thanks

Did you try the suggestion of post #5 ?

 

[Joe4]

Re: IF and OR forumal issue

Telling us it does not work and repeating what you said before is not helping us to help you.
As I said before,

If you think it is not, please provide an actual example along with your expected output.

Give us an ACTUAL example that is not working.
What is in cell AT2?
What is in cell BE2?
What is your expected output?

 

[willisd]

Re: IF and OR forumal issue

can anyone help on this at all? thanks

 

[Joe4]

Re: IF and OR forumal issue

can anyone help on this at all?

Not if you do not answer the questions we are asking.
We need you to help us to help you!

Please answer the questions I posted in my last response above.