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: