Hi Jay

do you mean this :-

=IF(ISBLANK(H18),"",IF(H18=4.5,0,H18-$I$2))
or
=IF(H18="","",IF(H18=4.5,0,H18-$I$2))

basically use the same method for the other two. (in the first & second
formula you posted the AND is redundant)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Jay" wrote in message
...
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?