Creation of a formula
 

I need a formula that can read all of these and provide me with the correct
results.

I have 4cells f1,f2,f3,f4. on these cells I select one only at a time and I
mark that cell with a "x"

I have cells:
a1
b1
c1
if a1B1 the formula has to look at f1 and f2, to see if any of those has an
"x", if there is an X the result should be the word "DENIED". IF a1C1 the
formula has to look at f3 and f4 if there is an "x" the result should be the
word "NAUR". if B1 and C1 are < A1 then the is no result, a simple "" to be
invisible is ok.

Hope this is clear enough. Thank for your help.

Creation of a formula
 

Try this:
=IF(AND(A1B1,OR(F1="x",F2="x")),"DENIED",IF(AND(A 1C1,OR(F3="x",F4="x")),"NAUR",""))

This is assuming that you type an actual x in the cell and that you will
only have one x at a time.

"Frances C" wrote:

I need a formula that can read all of these and provide me with the correct
results.

I have 4cells f1,f2,f3,f4. on these cells I select one only at a time and I
mark that cell with a "x"

I have cells:
a1
b1
c1
if a1B1 the formula has to look at f1 and f2, to see if any of those has an
"x", if there is an X the result should be the word "DENIED". IF a1C1 the
formula has to look at f3 and f4 if there is an "x" the result should be the
word "NAUR". if B1 and C1 are < A1 then the is no result, a simple "" to be
invisible is ok.

Hope this is clear enough. Thank for your help.

Creation of a formula
 

Does this formula do what you want?

=IF(A1B1,IF(OR(F1="x",F2="x"),"Denied","Not
Denied"),IF(A1C1,IF(OR(F3="x",F4="x"),"NAUR","Not NAUR"),""))

You didn't say what you wanted in a couple of cases, so I used Not Denied
and Not NAUR for them... you can change those to what you want.

Rick


"Frances C" wrote in message
...
I need a formula that can read all of these and provide me with the correct
results.

I have 4cells f1,f2,f3,f4. on these cells I select one only at a time and
I
mark that cell with a "x"

I have cells:
a1
b1
c1
if a1B1 the formula has to look at f1 and f2, to see if any of those has
an
"x", if there is an X the result should be the word "DENIED". IF a1C1 the
formula has to look at f3 and f4 if there is an "x" the result should be
the
word "NAUR". if B1 and C1 are < A1 then the is no result, a simple "" to
be
invisible is ok.

Hope this is clear enough. Thank for your help.