View Single Post
  #1   Report Post  
Jay
 
Posts: n/a
Default 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?