PO# Formula displaying False =IF(AND(LEN(B30),LEN(C30),LEN(D30)),TEXT(B30,\"mmdd

Question

PO# Formula displaying False

=IF(AND(LEN(B30),LEN(C30),LEN(D30)),TEXT(B30,"mmdd")&VLOOKUP(C30,$L$6:$M$24,2,FALSE)&VLOOKUP(D30,$N$5:$O$24,2,FALSE)&(T30))

This Formula is making the cell display false =IF(B30=B29,T1+1,1)

If I delete &(T30) At the end of my main formula it works properly and does not display anything until cell B,C,D are filled in. I need the count at the end of the PO#. How do I stop the formula from displaying False? The count is in a different cell because it messes up the PO#s in column A.

Explanation / Answer

Try this

=IF(AND(LEN(B30),LEN(C30),LEN(D30)),TEXT(B30,"mmdd")&VLOOKUP(C30,$L$6:$M$24,2,FALSE)&VLOOKUP(D30,$N$5:$O$24,2,FALSE)&(T30),"")

Hope this helps.

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.