Using an If statement

  • Thread starter Thread starter kmt1984
  • Start date Start date
K

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!
 
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!
Click to expand...

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
 
kmt1984 said:
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
Click to expand...

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 -----
 
Back
Top