Hi guys,
I am currently working on some stats for a fantasy sport game, I play with some mates and need to work out how to output a yes or no for a conditional result.
Basically, my form looks like this.
N3 O3 P3 Q3 5 16 143 Formula to go here
So, basically what I am trying to work out is. I need the Q3 to first work out if the P3 =>150 (equal or larger than 150) it will result "YES". Which it can stop and not check the 2nd condition. If it is a no, it will then go to check the second condition. Which is checking if the N3+O3 => 40 (equal or larger than 40) it will also result with "Yes". Otherwise it will just result "No".
I have been trying my best to work out the formula myself but am getting more and more confused and running out of days before the season starts.
If anyone is able to help that would be great.
Cheers,
Twiztid
Bookmarks