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

 

[dreid1011]

Re: IF and OR forumal issue

=if(or(AT2<date(2017,7,24),"settled",if(or(be2<=date(2018,2,28),"settled","not settled?"))

First thing I see is a missing " at the end. Second.. you are using OR with only one test each. Perhaps this:

=IF(OR(AT2<DATE(2017,7,24),BE2<=DATE(2018,2,28)),"Settled","Not Settled")

 

[philwojo]

Re: IF and OR forumal issue

If you are using < > in your formula put a space between them or it won't post correctly here.

 

[Joe4]

Re: IF and OR forumal issue

I think your formula is being chopped, so we cannot see it.
I am guessing it is because you are using < and/or > signs in your formula.
If you are, please post again, but put spaces before and after these signs, like this:
=if(or(AT2<date(2017,7,24),"settled",if(or(be2<=date(2018,2,28),"settled","not settled"))
< 10,...

The issue is that these signs are also used in HTML code (which this forum uses), and it think you are trying to add HTML code there and not literal < or > signs.</date(2017,7,24),"settled",if(or(be2<=date(2018,2,28),"settled","not>

 

[Aladin Akyurek]

Re: IF and OR forumal issue

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

Shortened...

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

 

[willisd]

Re: IF and OR forumal issue

many thanks all but I still have issues even if I use the formula suggested by dreid1011.
=IF(OR(AT2<DATE(2017,7,24),BE2<=DATE(2018,2,28)),"Settled","Not Settled")

What I am trying to do is say that if AT meets that criteria then return "settled" otherwise go to BE and then return based on that criteria.

Thanks

 

[Joe4]

Re: IF and OR forumal issue

What I am trying to do is say that if AT meets that criteria then return "settled" otherwise go to BE and then return based on that criteria.

Then I think what you have here is just a nested IF. You do not need any OR statements.

[COLOR=#574123]=if(AT2 [/COLOR][B]< date(2017,7,24),"settled",if(be2 [B]<= date(2018,2,28),"settled","not settled?[COLOR=#ff0000]"[/COLOR]))[/B][/B]

 

[philwojo]

Re: IF and OR forumal issue

Well assuming this was your original formula:

[COLOR=#333333]=if(or(AT2[/COLOR][B]<date(2017,7,24),"settled",if(or(be2[B]<=date(2018,2,28),"settled","not settled?[COLOR=#ff0000]"[/COLOR]))[/B][/B]

Then try this:

[COLOR=#333333]=if(AT2[/COLOR][B]<date(2017,7,24),"settled",if(be2[B]<=date(2018,2,28),"settled","not settled?[COLOR=#ff0000]"[/COLOR]))[/B][/B]

 

[Joe4]

Re: IF and OR forumal issue

many thanks all but I still have issues even if I use the formula suggested by dreid1011.
=IF(OR(AT2<DATE(2017,7,24),BE2<=DATE(2018,2,28)),"Settled","Not Settled")

What I am trying to do is say that if AT meets that criteria then return "settled" otherwise go to BE and then return based on that criteria.

I am curious though. If both "checks" are to return the same thing ("Settled"), then the OR statement dreid1011 should work just as well as the Nested If.
If you think it is not, please provide an actual example along with your expected output.

 

[willisd]

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