Please could someone help me - I just don't seem to get it right
I need to write a formula - I've tried to be as clear as possible :
If Overall Potential is greater than 8 but less than 10 and Potential Q4 is equals 1 number return the number 1
I need to write a formula - I've tried to be as clear as possible :
Potential Q4: Do they want the challenge right now? | Overall Potential Calculation | Potential Calculation |
3 | 8 | 1 |
3 | 8 | 1 |
If Overall Potential is greater than 8 but less than 10 and Potential Q4 is equals 1 number return the number 1
If Overall Potential is greater than 8 but less than 10 and Potential Q4 is greater than 1 return the number 2 The answer is in Potential Calculation |