Thread
:
Challenge for Anyone to take it on.
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_]
external usenet poster
Posts: 1,766
Challenge for Anyone to take it on.
Hi,
In a separate range (G11:I15), enter the following
184 224 E
225 284 D
285 344 C
345 404 B
Now you can use the following formula
=vlookup(sum(A1:A3),G11:I15,3)
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"SO CONFUSED" <SO
wrote in message
...
I want a Formula that will answer the following.
EG:
110
110
124 =
344 D
The =sum 344 part i have done..
Problem i have is the following: I want a function that will find it
between
a range of numbers and give a letter answer.
For Example
if answer is between
345:404 answer is B
285:344 answer is C
225:284 answer is D
184:224 answer is E
The next part is I need the formula to be able to change if i change the
sum. So if the sum answer is changed and the new answer is 345 for example
it
would now be B now and not C.
Please Help.... ANYONE
FROM SO CONFUSED
Reply With Quote
Ashish Mathur[_2_]
View Public Profile
Find all posts by Ashish Mathur[_2_]