Help with If(Len greater than 0

[aedctalk]

Hello. I can't get this to work for some reason..

My P90 text always shows up no matter what

=IF(LEN(E62<>0),P90&" ", "")

E62 currently shows zero...

I want this message to appear only when e62 is not equal to zero.

What am i doing wrong please?

Thank you!!

 

[jeffreybrown]

How about...

=IF(LEN(E62)<>0,P90&" ", "")

 

[njimack]

If you're simply testing whether E62 is equal to zero, you don't need to test it's length.

=IF(E62=0,"",P90&" ")

 

[T. Valko]

Hello. I can't get this to work for some reason..

My P90 text always shows up no matter what

=IF(LEN(E62<>0),P90&" ", "")

E62 currently shows zero...

I want this message to appear only when e62 is not equal to zero.

What am i doing wrong please?

Thank you!!

You have the operator within the LEN function.

Try it like this...

=IF(LEN(E62),P90&" ","")

Or, maybe...

=IF(E62<>"",P90&" ","")

 

[Scott Huish]

Why are you appending a space at the end of P90?

=if(e62="","",p90&" ")