Creation of a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 a1>B1 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 a1>C1 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.
 
Try this:
=IF(AND(A1>B1,OR(F1="x",F2="x")),"DENIED",IF(AND(A1>C1,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.
 
Does this formula do what you want?

=IF(A1>B1,IF(OR(F1="x",F2="x"),"Denied","Not
Denied"),IF(A1>C1,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
 
Back
Top