Help with If Function

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

Guest

Can someone help me fix this because it doesn't seem to work and I don't know
where to go from here?

=IF(A3>19&B3>17,"1",IF(A3>29&B3<17,"2",IF(A3<29&B3>17,"3",IF(A3<29&B3<17,"4"))))
 
You need to tell us what you're trying to do.

=IF(AND(A3>19,B3>17),"1",IF(AND(A3>29,B3<17),"2",IF(AND(A3<29,B3>17),"3",IF(AND(A3<29,B3<17),"4"))))

Regards,
Paul
 
Maybe...

=IF(and(A3>19,B3>17),1,IF(and(A3>29,B3<17),2,
IF(and(A3<29,B3>17),3,IF(and(A3<29,B3<17),4))))

But it looks like you're missing a value (when B3=17, for example).

maybe...

=IF(AND(A3>19,B3>17),1,IF(AND(A3>29,B3<17),2,
IF(AND(A3<29,B3>17),3,IF(AND(A3<29,B3<17),4,"whatgoeshere"))))

ps. I changed your text numbers to number numbers.
 
Hi Joy,

Paul & Dave have answered your question but I just thought I'd
add an observation. As if the English language didn't have enough
ambiguities, the Excel developers decided to add another.

In English
and = and
& = and = ampersand
+ = and = plus = positive

In Excel
and = and
& = and = ampersand
+ = and = plus = positive
and
AND <> and, it = "x" and "x"

A German friend of mine who is learning English has a very
descriptive terminology for these ambiguities, however, I
don't think it would be wise to share it on these forums. <g>

Regards
Martin
 
Back
Top