D
Danny Boy
I'm trying to figure out a formula that would produce the following flags"
based upon an evaluation form that patients are completing regarding the
services they received:
0-1.9=Definitely False
2.0-2.9=Mostly False
3.0-3.9=No Impact
4.0-4.9=Mostly True
5.0 or greater=Definitely True
The identifying issue are in Column A (e.g. staff was courteous), the raw
score outcomes are in Column B (3.91, 4.12, etc), and the formulas with the
identifying flags (e.g. No Impact, Mostly True, etc) are in Column C. In
total we are looking at 18 different indicators of service (e.g. courteous,
on time appointments, etc).
Example:
A B C
3 Courteous Staff 3.91 No Impact
I did attempt a formula, but it did not seem to work at 100%. Below is what
I came up with:
=IF(B3=0,"",IF(AND(B3>=0,B3<=1.9),"Definitely
False",IF(AND(B3>=2,B3<=2.9),"Mostly False",IF(AND(B3>=3,B3<=3.9),"No
Impact",IF(AND(B3>=4,B3<=4.9),"Mostly True","Definitely True")))))
Please note that if no value was yet indicated in column B, I wanted column
C to remain blank (no flag response at all). For this reason I had the
following as part of the formula:
=IF(B3=0,"",
Any help would be greatly appreciated!
Thank you in advance,
Dan
based upon an evaluation form that patients are completing regarding the
services they received:
0-1.9=Definitely False
2.0-2.9=Mostly False
3.0-3.9=No Impact
4.0-4.9=Mostly True
5.0 or greater=Definitely True
The identifying issue are in Column A (e.g. staff was courteous), the raw
score outcomes are in Column B (3.91, 4.12, etc), and the formulas with the
identifying flags (e.g. No Impact, Mostly True, etc) are in Column C. In
total we are looking at 18 different indicators of service (e.g. courteous,
on time appointments, etc).
Example:
A B C
3 Courteous Staff 3.91 No Impact
I did attempt a formula, but it did not seem to work at 100%. Below is what
I came up with:
=IF(B3=0,"",IF(AND(B3>=0,B3<=1.9),"Definitely
False",IF(AND(B3>=2,B3<=2.9),"Mostly False",IF(AND(B3>=3,B3<=3.9),"No
Impact",IF(AND(B3>=4,B3<=4.9),"Mostly True","Definitely True")))))
Please note that if no value was yet indicated in column B, I wanted column
C to remain blank (no flag response at all). For this reason I had the
following as part of the formula:
=IF(B3=0,"",
Any help would be greatly appreciated!
Thank you in advance,
Dan