Returning Null Valve in IF Statement

[TheLeafs]

Hey Folks,

In cell P13 I have the formula
=--IF(J13="","",IF(J13<=G13,$W$12,"")&IF(T13=4,$X$12,"")&IF(T13=3,$Y$12,"")&IF(T13=2,$Z$12,"")&IF(T13=1,$AA$12,"")& IF(T13=0,$AB$12,"")&IF(U13=4,$AC$12,"")&IF(U13=3,$AD$12,"")&IF(U13=2,$AE$12,"")&IF(U13=1,$AF$12,""))

As shown in the attached file. If cell J13 is blank, the formula returns a #Value message. I would like to see nothing in cell P13(“”). Any help would be great.

See associated thread below. My initial question was answered, but it caused another issue.

http://www.excelforum.com/excel-gene...ct-format.html

Thank you.

[Cutter]

Is this not a continuation of a previous post?

http://www.excelforum.com/excel-gene...ct-format.html