Nested If/Else logic not working as desired in formula

[H28Sailor]

Hi

see attached s/sheet

The F column is not behaving as I would expect

On the RHS is the overall formula I am tying to replicate

Comments please

Bob M

[6StringJazzer]

How are you expecting the F column to behave?

The logic you showed is more like code than a formula. It specifies results for multiple cells. You have nothing in the New Event column so I assume that is the one you need.

Please Login or Register  to view this content.

The places I wrote "unspecified" means that you have not specified a result for New Event for that condition.

[H28Sailor]

the formula I have :

=IF(AND(F3="Upturn",E3<=I2),"Downturn",IF(AND(F3="Downturn",E3>=J2),"Upturn",""))

[menem]

Your fomula is already worked, but we need to know how it should be calculate.

In K3 , it's blank because

=IF(AND(F3="Upturn",E3 < =I2),"Downturn",IF(AND(F3="Downturn",E3 > =J2),"Upturn",""))
AND(F3="Upturn",E3 < =I2) = False
AND(F3="Downturn",E3 > =J2) = False

Capture.JPG

Regards.

[H28Sailor]

F4 is my main problem

I expect it to be "Upturn" [i.e. F3] NOT blank

[6StringJazzer]

ISBLANK is true if a cell is empty, despite the name. K3 is not empty. It has a formula. Use this:

Please Login or Register  to view this content.