Help to Modify these guys

J

Jay

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?
 
J

JulieD

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

Jay

Julie:

Seems like that should work. Now I need these guys to the same:
=IF(AND(I19=0,J19=0),"Pass","Fail") If there is no refferenced cell data,
show nothing or "" only. How would one accomplish that?

Thanks,
 
J

JulieD

Hi Jay

=IF(AND(ISBLANK(I19),ISBLANK(J19)),"",IF(AND(I19=0,J19=0),"Pass","Fail"))
which will return "" if both are blank
if you want "" returned if either one is blank change the AND to an OR
 
J

Jay

Julie:

Thanks for that one too. However, if both of the refferenced cell contains
"", the formula returns a "Fail". Which is okay, if things were not what they
are. If the refferenced cell do contain "" for a value, then, ALL I want to
see is a "", and not "FAIL" or "PASS". Just BLANK!

Maybe, I did not explain myself clearly enough before. Thanks for ALL your
assistance on this!
 
Top