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.

=IF(AND(OR(ISNUMBER(A2);ISNUMBER(A3);ISNUMBER(A4))*ISNUMBER(C2));"Hello";"Blargh)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:

=IF(AND(OR(OR(ISNUMBER(A2);ISNUMBER(A3);ISNUMBER(A4))ISNUMBER(A10))*ISNUMBER(C2));"Hello";"Blargh)Thanks for making me understand a bit more. :)

Why not start with the simplest case first: Is A10 a number? =IF(ISNUMBER(A10),"Hello",IF(AND(OR(ISNUMBER(A2),ISNUMBER(A3),ISNUMBER(A4)),ISNUMBER(C2)),"Hello","Blargh")

An IF statement stops checking the conditions as soon as it finds something that is TRUE, so check A10 first.

Oh God, I can't understand how I didn't think about using two IF's. Thanks a million, it works like a charm!

It can also be done with a single IF, but it might be a bit more confusing: =IF(OR(ISNUMBER(A10),AND(OR(ISNUMBER(A2),ISNUMBER(A3),ISNUMBER(A4)),ISNUMBER(C2))),"Hello","Blargh")

Again, the IF will stop as soon as a TRUE is found, which could be the ISNUMBER(A10) within the first OR.

Ask Your Question

Weekly Poll

Do you think Europe's new data protection laws will affect you?

Discuss in The Lounge

Poll History