IF Statement for a whole row

edited 12/09/19 in API & Developers
05/15/18 Edited 12/09/19

Hello!

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!!!

Comments

  • Mike WildayMike 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 WildayMike Wilday ✭✭✭✭✭

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

Sign In or Register to comment.