View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default A formula answer that I just can't wrap my brain around!

hi
if i understand correctly, try something like this....
=IF(D5C5,"Got Better",IF(D5=C5,"Stayed Same","Got worse"))
adjust cell references as needed.

Regares
FSt1

"Dan the Man" wrote:

I received great help on an early formula, and I'm trying to analyze my data
one other way, and can't seem to think of the best way to write out what I
need. Here goes an example. Any help would be greatly appreciated:

Disch Program Q #1 Q #1
Date at Admit at Disch

Column A Column B Column C Column D

Sep 1, 08 CIC 5 15
(Improvement)
Sep 15, 08 TP 10 10
(Stayed the Same)
Sep 21, 08 CIC 10 5
(Got Worse)
Sep 22, 08 CIC 5 5
(Stayed the Same)
Sep 22, 08 TP 15 10
(Got Worse)

What I want to compare a improvement, stayed the same, and got worse
within each program. Thus, in the above example, I would look at Improvement,
stayed the same or got worse for individuals in our CIC program separately
from individuals in TP or OP. What I want to obtain is a raw score value that
would tell me:

Of the (3) CIC individuals discharged: 1 Improved, 1 stayed the same, and 1
got worse. I'll do this for the individuals in OP and TP separately, but once
I get one formula I should be able to figure out the others. HELP, I can't
wrap my mind around it. I'm grabbling the data off of one sheet (entitle:
'Raw Data'!), and placing it on another sheet (outcomes). Thus I know I need
to reference/qualify the raw data sheet using the above string of formula as
I attempt to generate the information on my outcomes sheet.

Any suggestions? Hope I provided enough information to solve the formula!

Dan