View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SO CONFUSED SO CONFUSED is offline
external usenet poster
 
Posts: 2
Default Challenge for Anyone to take it on.

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