Forum Discussion

ReggieMitchell's avatar
ReggieMitchell
Copper Contributor
Nov 10, 2023
Solved

If(OR formula with >= as one criteria and if(sum(a1:a5)=5 as second criteria

I am trying to create an If(OR formula in Excel.

I want one of two possible criteria's for a match (1), otherwise place a 0.

However, I can't seem to add a SUM criteria correctly. I keep getting all manner of syntax errors from the following:

 

=IF(OR(C3>=2.7,IF(SUM(A42:A46)=5),1,0)

 

The logic of the above formula that I am attempting is:

IF(OR(GPA>=2.7, otherwise if Sum of 5 cells = 5, then place a "1" if True, otherwise a 0 if False.

IF(OR(C3>=2.7,=IF(SUM(A42:A46)=5),1,0)

 

 

Resources