"If" statements

[Lil~Bit]

Another one for all you wonderful people on here!

I have a spreadsheet that has multiple columns and rows of data, which I guess is the point of a spreadsheet. However, I need one column to do and return specific things.

In column B, I would like the following to happen.

If column C is less than 8999 and column G contains the word "Hello" anywhere in the cell, return the value "500". If column C is greater than 8999 return the value in column C.

Is that possible? I can get each one to work individually and all is fine. I have tried nesting these functions, but I cannot get the entire thing to work.

Thanks in advance!

 

[Lil~Bit]

Never mind!

I had the cells in C2 formated as TEXT!!! I hate how it is always something so simple that throws me off. Once I converted to a number, it was fine!!!

Thanks for your help!!!

I copied your cell over, but it returns a blank. How can I attach what I have so you can view it?

 

[Aladin Akyurek]

Never mind!

I had the cells in C2 formated as TEXT!!! I hate how it is always something so simple that throws me off. Once I converted to a number, it was fine!!!

Thanks for your help!!!

Great. Thanks for providing feedback.

 

[Trouttrap2]

Does this give you the desired result? I modified to fit your actual criteria.

=IFERROR(IF(AND(C2<9000,SEARCH("Boyne",G2)>0),631,C2),C2)

Thanks!
That is getting better results for every cell except the ones that contain Boyne (yes, I did change the Boyner ... lol). It is still not returning 631 where G2 contains Boyne and C2 is less than 9000. The other part works great!