|Hello, people. You helped me perfectly last time, and I'm just in a bit of a rut again, as I've been cluttering about with this formula for an hour. I'm not an expert, to say the least.|
Anyways, I'd like to have the following happen:
If A10 contains a number, write "Hello" to B2.
If either A2, A3 or A4 TOGETHER with C2 contains a number, write hello to B2.
By logic reasoning I came up with this for my second line.
Now, this works quite all right. But how can I get the formula to regardless of values in C2, A2, A4 and A4 display "hello" if there is a number in A10?
I've experimented with using another (OR), but I'm not sure where to put it, as my formula is screwing up hard on me.
I was thinking something like:
Thanks for making me understand a bit more. :)