Excel

  • Thread starter Thread starter Kat
  • Start date Start date
K

Kat

I am trying to create a formula that has three
determinants and as a result labels a rating of 1, 2.
This is how they would rate: Say you have in column A
11.5% and in B -35.2%.

 if A is to B at least 2:1 and is more than 15% than you
would get a rating of 1
 if A is to B at least 1:1 and is more than 15% than you
would get a rating of 2

So my question is how do you enter more than one condition
resulting in more than one answer? Please help.
 
Kat:

Try nesting IFs and ANDs like this:

=IF(AND(A4/B4>2,A4>0.15),1,IF(AND(A4/B4>1,A4>0.15),2,"Neither"))

With your sample numbers this would result in Neither. Maybe this is not
what you want, but you should be able to use the nested IF/AND idea to get
what you want.

Bruce Cooley


: I am trying to create a formula that has three
: determinants and as a result labels a rating of 1, 2.
: This is how they would rate: Say you have in column A
: 11.5% and in B -35.2%.
:
:  if A is to B at least 2:1 and is more than 15% than you
: would get a rating of 1
:  if A is to B at least 1:1 and is more than 15% than you
: would get a rating of 2
:
: So my question is how do you enter more than one condition
: resulting in more than one answer? Please help.
:
 
Back
Top