C
contrarian
Hi,
I'm wondering if some kind person might be able to help with a proble
I have in putting together the correct "IF" statement. I'll try and b
as clear as possible (what I'm actually trying to accmplish is prett
simple - but I can't get the formula right):
(a) Column A has numbers
(b) Column B has numbers
In the calculation column (say, column C will do!) I want it to look a
a few conditions, and if met, put a word in that column (say, "fish"!)
Let's start down the list a little way in cell C6, because it refer
back to 5 numbers in column B and 1 number in column C.
Okay, these are the simple conditions: (remember, we're starting i
cell C6)
(1) If B6 is greater than B5
(2) And B6 is also greater than A5 (next door)
(2) And B6 is also less than B4, less than B3, less than B2 and les
than B1
Then put the word "FISH" there.
I do not want it to put anything if those conditions are not met.
Does anyone know how to write the correct IF statement to do this?
(Please note: if it MUST say something when the conditions are not met
I can live with that).
Thanking you heaps,
Stev
I'm wondering if some kind person might be able to help with a proble
I have in putting together the correct "IF" statement. I'll try and b
as clear as possible (what I'm actually trying to accmplish is prett
simple - but I can't get the formula right):
(a) Column A has numbers
(b) Column B has numbers
In the calculation column (say, column C will do!) I want it to look a
a few conditions, and if met, put a word in that column (say, "fish"!)
Let's start down the list a little way in cell C6, because it refer
back to 5 numbers in column B and 1 number in column C.
Okay, these are the simple conditions: (remember, we're starting i
cell C6)
(1) If B6 is greater than B5
(2) And B6 is also greater than A5 (next door)
(2) And B6 is also less than B4, less than B3, less than B2 and les
than B1
Then put the word "FISH" there.
I do not want it to put anything if those conditions are not met.
Does anyone know how to write the correct IF statement to do this?
(Please note: if it MUST say something when the conditions are not met
I can live with that).
Thanking you heaps,
Stev