Using an If statement

[kmt1984]

I have been searching the discussion boards and haven't found the answer to
my question.

Basically, if B7, B13 B42, B44, etc. have anything entered I would like A55
to say Fail. I have been trying using IF and OR statements, but can't seem
to get it to work.

Any help is appreciated!

 

[Lars-Åke Aspelin]

I have been searching the discussion boards and haven't found the answer to
my question.

Basically, if B7, B13 B42, B44, etc. have anything entered I would like A55
to say Fail. I have been trying using IF and OR statements, but can't seem
to get it to work.

Any help is appreciated!

You have to define what "etc" is.
You should also specifiy what you want A55 to say when it shoulf not
say "Fail".

Assuming that "etc" can be disregarded and that A55 should say "" if
not "Fail", try the following formula:

=IF(OR(B7<>"",B13<>"",B42<>"",B44<>""),"Fail","")

Hope this helps / Lars-Åke

 

[Gary Brown]

=if(or(len(b7)=0,len(b13)=0,len(b42)=0,len(b44=0),"FAIL","PASS")

 

[Joe User]

Basically, if B7, B13 B42, B44, etc. have anything
entered I would like A55 to say Fail. I have been
trying using IF and OR statements

For educational purposes, you should post what you have been trying. But
the following should do the trick (in A55)

=if(B7 & B13 & B42 & B44 = "", "", "Fail")

This returns the null string ("") and appears blank if all cells appear
blank, a condition that you neglect to specify.


----- original message -----