Home Forum Chat Forum Very very basic Excel 2010 question/problem

Viewing 7 posts - 1 through 7 (of 7 total)
• Very very basic Excel 2010 question/problem
• euain
Subscriber

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

Johnny Panic
Subscriber

What if Yes is in more than one column? Or is that not possible?

Stoner
Subscriber

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”)))

miketually
Subscriber

As above, you need nested IFs, assuming only one of columns K, N or P can contain a yes.

Johnny Panic
Subscriber

=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 🙁 )

codybrennan
Member

Great stuff, got it working thanks. I was thinking I needed specific ‘if-then-else’ statements but see how this works now.

Thanks all-

codybrennan
Member

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?

Viewing 7 posts - 1 through 7 (of 7 total)

The topic ‘Very very basic Excel 2010 question/problem’ is closed to new replies.