I have a small table that looks as followed;
I am trying to have the invest or do not invest auto populate, the factors are; B > 5% and C > 8% or D > 5
I am using the following formula;
=IF(AND(OR(B7>=5%,C7>=8%),OR(D7>=5)),"Invest","Do not invest")
It works for some of the rows but not all of them?
For example rows 7 and 9 should be "invest" as they meet the above criteria..