IF Statement for a whole row

edited 12/09/19 in API & Developers


I'm trying to use this if statement: 

=IF(OR([1]67:[30]67 = "R13"), "500", "")

But it's not working when I want it to check the whole row ([1]67 through [30]67) for R13. Is there another way for me to do this statement?


Thank you!!!


  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    edited 05/15/18

    Well... since IF formulas don't usually check ranges what about using the Countif formula integrated into an IF statement

    Try this... =IF(Countifs([1]67:[30]67, "R13") > 0, "500", "")

    Also, by putting 500 in quotations you are turning the integer into a text format. If you are using that amount as a number you can remove the quotes like this. 

    =IF(Countifs([1]67:[30]67, "R13") > 0, 500, "")

    This will count if there are any occurrences of R13 and return how many. If that number is greater than 0 then you will return 500. 

  • Completely understand, thank you so much for your help!



  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    You're welcome! Glad I could be of assistance.