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!

On Wed, 14 Apr 2010 11:53:01 -0700, kmt1984
wrote:

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

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

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"kmt1984" wrote:

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!

"kmt1984" wrote:
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 -----

"kmt1984" wrote:
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!