Formula help req'd

[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
PS: I have posted in excel worksheet function forum too.

 

[JulieD]

Hi Paul

no need normally to post in more than one ng

=IF(A3>=4,"HW",IF(A3>=0,"HD",IF(A3>=-5,"AD","AW")))

in A4 should give you what you need

Cheers
JulieD

 

[Peo Sjoblom]

First,there is no need for the sum formula,

=A1-A2 will do

then you can use

=VLOOKUP(A1-A2,{-99999999999,"AW";-5,"AD";0,"HD";4,"HW"},2)

I used -99999999999 assuming that you won't get a smaller number than that
If you know that you won't ever get something less than -100 you can replace
it by that

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom