Formula help reqd

  • Thread starter Thread starter paul thomas
  • Start date Start date
P

paul thomas

Hi there

I am having trouble trying to display result.

Basically say A1 has 10 in it and A2 has 5 in it A3 has the formula
A3 =sum(A1-A2) {answer =5}

What I want it do do is... say A4 displays HW as per the key.
so if A1 = 2 and A2 = 7 A3 answer is -5 - A4 then displays AD and so on

the key
0 to 3 = HD
4 + = HW
-1 to -5 = AD
-6 + = AW

Any help gratefully appreciated.

cheers
Paul
 
Hi

Try this:
=IF(A1-A2<=-6,"AW",IF(A1-A2>=4,"HW",IF(AND(A1-A2>=0,A1-A2<=3),"HD","AD")))
I think that should be right!!
 
Paul,

Try:
=IF(AND(A3>=0,A3<=3),"HD",IF(AND(A3>=4),"HW",IF(AND(A3>=-5,A3>=-1),"AD",IF(AND(A3>=-6),"AW"))))

Harry
 
Sorry Paul,
slight mistake:

=IF(AND(A3>=0,A3<=3),"HD",IF(AND(A3>=4),"HW",IF(AND(A3>=-5,A3<=-1),"AD",IF(AND(A3>=-6),"AW"))))

although Andy's is simplier!

Harry
 
Back
Top