 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
I'm really crap at Excel 🙂
I have 2 cells, side by side, each of which has a text result from another formula. Lets say that result #1 is in cell A10, result #2 is in cell A11. I'd like to stick my formula into cell A12:
What I want to do (in pseudo code) is:
If cell A10 has the value "dookie", and cell A11 does NOT have the value "nimrod", write the text "insomniac" into cell A12, else write the value "warning".
Its the NOT bit thats getting me confused. Can anyone help?
=if(and(A10="dookie", A11<>"nimrod"), "insomniac", "warning")
What are you, some kind of American Idiot?
I would give up on Excel and instead try Lotus Uno, Dos, Tres?
Thanks Stoner 🙂
I had missed the 3rd brace and had one too many at the end.
And thanks for the funnies guys 🙂
@cody I love the fact you told us the cells where side by side 🙂
I know jambalaya, like it mattered 🙂
So, an extension of this. What I'd now like to do is:
If the value of A8 ="Yes", and the value of A9 is NOT equal to "No", write "Yes" in A12, else write "No"
(and now this is the tricky bit)
CONTINUE the formula into- if A10="Yes", AND A11="Yes", write "Yes" in A12, else write "No".
I don't know if you can nest IFs in this way?
=IF(OR(AND(A8="Yes", A9<>"No"), (AND(A10="Yes", A11="Yes")), "Yes", "No"))
Im assuming here you mean OR, rather than AND as you havent said whether the A10/A11 IF statement is a secondary test or a parallell one.
Cheers Stoner,
Its a secondary test. I shall have a play!