Probably a very simple logical test...

[jab40]

Hi, I wonder if someone could help me write what I imagine is a very simple formula - I just can't work out how to write it!

I have two columns, each with scores in. The scores go 0, 10, 20, 30, etc up to 100.

I want the code to have three possiblities: i) If both scores are less than or equal to 50, output "Fail"; ii) if one is less than or equal to 50, and the other score is greater than 50, output "Re-test"; iii) if both scores are above 50, ouput "Pass".

Any suggestions gratefully received

 

[jab40]

Look at (A1>50)+(B1>50)+1. It's adding three things together:-

1. The truth of A1>50 (1 if true, 0 if false)
2. The truth of B1>50 (1 if true, 0 if false)
3. 1

So if the person passes both tests, this evaluates to (1)+(1)+1=3.
If they pass the first and fail the second, it evaluates to (1)+(0)+1=2.
If they fail the first and pass the second, it evaluates to (0)+(1)+1=2.
If they fail both tests, it evaluates to (0)+(0)+1=1.

I then use the value to pick the 1st, 2nd or 3rd item from the list.

Ah, great, I am with you.

Again, thankyou very much for taking the time.

BW

 

[jab40]

I've another one similar to this - any help appreciated!

I want to enter a formula that returns a particular value, depending upon a value within another cell.

If the value is < 12, return 1000.
If the value (n) is 12 <= n < 24, return 1300
If the value (n) is 24 <= n < 36, return 1600
If the value (n) >= 36, return 1900

Thanks in advance.