Hi all,
I'm making a calculator and will need to display a specific value based on the returned score. However, there are two values that will need to be taken into account in determining what will be displayed.
2 values:
- Score (C18)
- Count (D21)
The Score will be whatever the calculation returns
The Count will be entered in manually
The IF formula will need to return a value of either "High" "Med" "Low" or "OK"
Here's what the formula will need to do:
1) If Count = 1-25, then if Score > 65, "High", Score < 65, "Med", Score < 55 "Low", Score < 46, "OK"
2) If Count = 26-250, then if Score > 53, "High", Score < 53, "Med", Score < 45, "Low", Score < 36, "OK"
3) If Count = 251-1000, then if Score > 45, "High", Score < 45, "Med", Score < 38, "Low", Score < 31, "OK"
4) If Count = 1001-2500, then if Score > 38, "High", Score < 38, "Med", Score < 31, "Low", Score < 26, "OK"
5) If Count = >2500, then if Score > 30, "High", Score < 30, "Med", Score < 25, "Low", Score < 21, "OK"
If this is possible, and you can provide assistance, I'll be very appreciative
Thanks!
I'm making a calculator and will need to display a specific value based on the returned score. However, there are two values that will need to be taken into account in determining what will be displayed.
2 values:
- Score (C18)
- Count (D21)
The Score will be whatever the calculation returns
The Count will be entered in manually
The IF formula will need to return a value of either "High" "Med" "Low" or "OK"
Here's what the formula will need to do:
1) If Count = 1-25, then if Score > 65, "High", Score < 65, "Med", Score < 55 "Low", Score < 46, "OK"
2) If Count = 26-250, then if Score > 53, "High", Score < 53, "Med", Score < 45, "Low", Score < 36, "OK"
3) If Count = 251-1000, then if Score > 45, "High", Score < 45, "Med", Score < 38, "Low", Score < 31, "OK"
4) If Count = 1001-2500, then if Score > 38, "High", Score < 38, "Med", Score < 31, "Low", Score < 26, "OK"
5) If Count = >2500, then if Score > 30, "High", Score < 30, "Med", Score < 25, "Low", Score < 21, "OK"
If this is possible, and you can provide assistance, I'll be very appreciative
Thanks!
Last edited: