Two questions, same answer?

[bpflyr]

Here's what I am trying to do. I think these have similar solutions, I just think I am missing the obvious answer.

1. (This needs to go in cell L22). If C22="C560", then copy J22. If J22 has no data, then be blank.

2. (This needs to go in cell M22). If C22="C560" AND K22>0, then copy K22. If K22 has no data, then be blank.

Thank you in advance!!

 

[Joe4]

1. (This needs to go in cell L22). If C22="C560", then copy J22. If J22 has no data, then be blank.

=IF(AND(C22="C560",LEN(J22)>0),J22,"")

Note: Are you comparing to cell C560? If so, remove the quotes around it.

2. (This needs to go in cell M22). If C22="C560" AND K22>0, then copy K22. If K22 has no data, then be blank.

=IF(AND(C22="C560",LEN(K22)>0,K22>0),K22,"")

 

[bpflyr]

Thanks! That got it. By the way, I'm a little new to Excel, what does LEN stand for?

 

[tusharm]

Searched XL Help for 'LEN' (w/o the quotes)?

Thanks! That got it. By the way, I'm a little new to Excel, what does LEN stand for?