Greetings everyone,
I want to find the right formula for the attached (Excel worksheet). I want it to do the required calculation for both (1st round) and (2nd round) but only when either is higher or equal to (50). I would be more than grateful if someone could help me. I think it might be done with a (nested if) or (if and), I am not sure. The required column is (E)
I want to find the right formula for the attached (Excel worksheet). I want it to do the required calculation for both (1st round) and (2nd round) but only when either is higher or equal to (50). I would be more than grateful if someone could help me. I think it might be done with a (nested if) or (if and), I am not sure. The required column is (E)