Calculate if certain conditions are met in excel

ciaramcevoy · Sep 29th 2016

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!

cytop · Sep 29th 2016

Re: Calculate if certain conditions are met in excel

Possibly

[bfn]=IF(AND(AG5="OPEN", OR(AY5="OPEN", AY5="")), 1, 0)[/bfn]

Or something like that depending if I read it right.

Calculate if certain conditions are met in excel

Participate now!

Share