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 al...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Nov 10, 2023

    ReggieMitchell 

     

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

    or

    =(C3>=2.7)*(SUM(A42:A46)=5)

ReggieMitchell's avatar
ReggieMitchell
Copper Contributor
Nov 12, 2023
Thank you very much. It works like a charm.

Resources