IF statment

[JD_Excels]

So i have 3 sets of columns with data. How can i write on the right side of excel a formula that would do this


IF there is data on Column T, then select that data, if the data is 0 or blank then use column AD, if that column is 0 or blank , then use column AG, if that is 0 or blank just have N/A

 

[Joe4]

Try:

=IF(T5<>0,T5,IF(AD5<>0,AD5,IF(AG5<>0,AG5,"N/A")))

 

[Joe4]

Cross posted at: Choosing Data from Column Depending on Column Contents

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.
Be sure to follow & read the link at the end of the rule too!

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[JD_Excels]

Try:

=IF(T5<>0,T5,IF(AD5<>0,AD5,IF(AG5<>0,AG5,"N/A")))

THANK YOU!

 

[Joe4]

You are welcome.

And please be sure to follow the rules regarding Cross-Posting on both sides.
It is usually not necessary to post the same question across multiple boards simultaneously. I would advise to pick one forum and post there, and then wait a while.
If you do not get a response after a while, then you can try posting to another board, but if you do, please be sure to mention that you have cross-posted the question and provide links to the other questions in BOTH forums.

 

[JD_Excels]

This is the formula i am using, i dont understand why the column AD is not returning back?

 

[Joe4]

Since this is really a direct continuation/follow-up question about your original question, I have merged this back in to your original thread.
Any directly related follow-up questions about someone's solution should be posted back to the original thread.
Only start a new thread with a new question.

In order for us to help you, we need to be able to see what is in cells: AG142, T142, and AD142
We cannot tell that from your screen prints (I cannot even make out the row numbers, as you cut those off in your images).