• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

The Right Formula

Hozan90

New Member
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)
 

Attachments

  • the right formula.xlsx
    10.8 KB · Views: 4
I know, I am sorry. I will put a formula now. When (the final mark) is >=50. For both rounds
 

Attachments

  • thread.xlsx
    9.8 KB · Views: 7
You still have not shown the calculation desired for column E.

The logic is

=IF(AND(F9>=50,H9>=50),some_calculation,"")

Replace some_calculation with whatever calculation you want to do in column E.
 
Back
Top