I need some help on how to make this MS Excel formula work for me.?

Question

If Cell PM Base'!I33 has some text AND PM Base'!D161 has no text then display "This Text". But if PM Base'!I33 has no text then do nothing or don't display anything.

This is what I have put together so far but its displaying "This Text" no matter what.

=IF((AND('PM Base'!I33>0,'PM Base'!D161>0)),"","Addressing File")

Thanks.

Answer 1

If by 'some text' you mean non-numeric, and by 'no text' you mean blank then:

=IF(AND(ISTEXT(PM Base'!I33),PM Base'!D161=""),"","Addressing File")

Answer 2

im fairly good with excel... but im not understanding what your after?

do u want D161 to be blank if I33 has text in it?

hmm. e-mail me and i can help u out more. plus the file itself would be helpful.

since entering the formula u put up is useless if we dont have the PM Base file.

Answer 3

I would use Excel's LEN function to test the length of the values in your target cells - seems to work well for me. Your formula appears that you are seeking to show "Addressing File" if there is missing text, which you could do like this:

=IF((AND(LEN('PM Base'!I33)>0, LEN('PM Base'!D161)>0)),"","Addressing File")

In your post, however, you were looking for "This Text" if D33 had text but D161 did not, or no text if I33 had no text (you did not indicate what would happen if neither were true). This might help get you closer to that solution:

=IF((AND(LEN('PM Base'!I33)>0,LEN('PM Base'!D161)=0)),"This Text",IF(LEN(I33)=0,"","Neither is true"))