IF Statement for a whole row

Lisi

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

Mike Wilday

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. 

Lisi

Completely understand, thank you so much for your help!

 

 

Mike Wilday

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