Getting rid of #VALUE! Excel Formula

[tHE fLY]

hi everyone!,

I am running into a #VALU! error wen running this formula for certain cells. I would like to show a Blank cell is the value is not available.

Any help would be appreciated.

=IFERROR(IF(OR(P$50="x",Q$49>0,O$49>0),ROUND(N62*Q$16/12,2),""),IF(L$29-E29 >365,ROUND(N62*Q$16/12,2)))

 

[bbott]

The way this is written, your second IF statement will be executed only when the first IF statement produces an error, not when it's false. Maybe try it like this:

=IFERROR(IF(OR(P$50="x",Q$49>0,O$49>0),ROUND(N62*Q$16/12,2),IF(L$29-E29 >365,ROUND(N62*Q$16/12,2))),"")

 

[NeonRedSharpie]

=IFERROR(IFERROR(IF(OR(P$50="x",Q$49>0,O$49>0),ROUND(N62*Q$16/12,2),""),IF(L$29-E29>365,ROUND(N62*Q$16/12,2))),"")

Just nest it in another =iferror