Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
refer some letter from one cell(pipe/mech or mech/pipe (reqd: pi) | Excel Worksheet Functions | |||
Codes Reqd. to create Loading Slip | Excel Discussion (Misc queries) | |||
Columns Counting Function Reqd | Excel Worksheet Functions | |||
Complicated sumproduct help reqd. | Excel Worksheet Functions | |||
FORMULA REQD FOR ADD ING DATES AND VALUES AND PART NUMBERS | Excel Discussion (Misc queries) |