Forum Discussion

Sam Bird Bird's avatar
Sam Bird Bird
Copper Contributor
May 02, 2018
Solved

IF / OR Functions

Hi,   I am trying to get Excel to insert the number 2 (onto a scorecard) when a number falls between 2 ranges.   Essentially what I want it to do is if the number falls between 350 - 550 or 650 -...
Excel Desktop
Formulas & Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    May 03, 2018

    Hi Sam,

    =IF(OR(AND(C2>349,C2<=550),AND(C2>650,C2<=800)),"2","")
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 03, 2018

Hi Sam,

=IF(OR(AND(C2>349,C2<=550),AND(C2>650,C2<=800)),"2","")
  • Sam Bird Bird's avatar
    Sam Bird Bird
    Copper Contributor
    May 03, 2018

    That is perfect. Thanks so much Sergei

Resources