Calculate if certain conditions are met in excel

  • Hi,


    This should be easy but I'm struggling I am trying to calculate if cell AG = Open and if cell AY = Open OR Blank. Here is the formula I've used but it isn't calculating correctly =IF(OR(AY3="open",AY3=" ",AND(AG3="open")),1,0). Any help really appreciated!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!