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