IF Statement for a whole row

Lisi
Lisi ✭
edited 12/09/19 in API & Developers

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

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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. 

    · Share on FacebookShare on Twitter
  • Lisi
    Lisi ✭

    Completely understand, thank you so much for your help!

     

     

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

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

    · Share on FacebookShare on Twitter

Categories