IF(LEN) within IF(AND( .. having issues..

[aedctalk]

Ok what i'm trying to do is .. If AB5 is greater than the value in configuration J17 AND if there is something typed in W5 then i want to display V5 .. otherwise i want "" (nothing)

I keep getting formula error for below though. How could i modify to get working? :/ Thanks so much :D

=IF(AND(AB5>Configuration!$J$17,IF(LEN(W5)),V5,""))

 

[MrKowz]

Close! There isn't a need for the IF inside of the AND statement. Try:

=IF(AND(AB5>Configuration!$J$17,LEN(W5)>0),V5,"")

 

[Aladin Akyurek]

If AB5 houses any formula...

=IF(N(AB5)>Configuration!$J$17,IF(LEN(W5),V5,""),"")