Help to Modify these guys
I need these three functions which work well to not display any thing or ""
if there is no data to calculate against.:
==========
=IF(AND(H18=4.5),0,H18-$I$2)
=IF(AND(H3<=5.5),0,H3-$J$2)
=IF(AND(I3=0,J3=0),"Pass","Fail")
==========
Can some one show me how to modify these three functions to not show any
value if there is no data in the refferenced fields?
If there is, HOW?
|