formula help reqd please
 

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.

formula help reqd please
 

On Fri, 18 Jun 2004 10:23:44 +0100, paul thomas wrote:

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.

Try this (works for me):
=IF(A3=4,"HW",IF(A3=0,"HD",IF(A3=-5,"AD","AW")))

FWIW, I (personally) would change A3 to "=A1-A2".
--
auric underscore underscore at hotmail dot com
*****
This post is rated PG-13.