You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
No idea about using Excel other than putting in values and colouring them in. (Well, I have dabbled with vlookup in the past, but apart from that- clueless).
I have a spreadsheet with values in columns. What I'd like to do, in pseudocode, is:
Look at Column K. Is the text in it saying "Yes"? If so, print "Column K=Yes" in Column T
else
Look at Column N. Is the text in it saying "Yes"? If so, print "Column N=Yes" in Column T
else
Look at Column P. Is the text in it saying "Yes"? If so, print "Column P=Yes" in Column T
else print "Nothing available" in Column T.
Thats it. This isn't part of my regular job, but someone has dumped this on me, and I need to do it for Monday morning.
Any clues?
You can do it with something like a formula in Column T looking something like this..
=if(K2="Yes","Column K = Yes",if(N2="YES","Column N = YES",if(...)))
There may be easier / cleaner ways to do it but the above will work
What if Yes is in more than one column? Or is that not possible?
You require "Nested If Statements".
IF statements go:
=IF(Logical test is True, then this, else this)
So, in T1 the forumla is:
=IF(K1="Yes, "Column K = Yes", IF(N1="Yes", "Column N = Yes", IF(P1="Yes", "Column P = Yes", "Nothing Available")))
As above, you need nested IFs, assuming only one of columns K, N or P can contain a yes.
=IF(K1="Yes","Column K=Yes",IF(N1="Yes","Column N=Yes",IF(P1="Yes","Column P=Yes","Nothing Available")))
Stoner's entry corrected 🙂
(Mine edited for Caps 🙁 )
Great stuff, got it working thanks. I was thinking I needed specific 'if-then-else' statements but see how this works now.
Thanks all-