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 2The answer is in Potential Calculation |