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)))
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)))