# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a formula for a series of 4 cells that is pulling information from another area. I now want to copy the text if one of the formulas comes back with a result
Solved by T. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 08/07/2018 - 10:42
Hello! Welcome, Thanks for choosing Got It Pro-Excel. How may I help you today?
User 08/07/2018 - 10:43
ok i added formulas in b4-b6
Excelchat Expert 08/07/2018 - 10:43
ok perfect
User 08/07/2018 - 10:43
i am looking to create a formula then copies any test that is in there
Excelchat Expert 08/07/2018 - 10:44
copy?
User 08/07/2018 - 10:44
i dont have my other document but basically those 3 values will either all be blank, or 1 will have text
User 08/07/2018 - 10:44
if there is text in cell B4:b6 then put the text in this cell
Excelchat Expert 08/07/2018 - 10:44
oook,
Excelchat Expert 08/07/2018 - 10:44
I understand
Excelchat Expert 08/07/2018 - 10:45
i will use the cell D5 as example
Excelchat Expert 08/07/2018 - 10:46
I think is that
User 08/07/2018 - 10:48
looks like it
Excelchat Expert 08/07/2018 - 10:48
try the formula please, is that what you want to get?
User 08/07/2018 - 10:48
yup that is exactly what i needed
Excelchat Expert 08/07/2018 - 10:48
awesome!
Excelchat Expert 08/07/2018 - 10:49
Let me explain exactly what I did
User 08/07/2018 - 10:49
i am following the logic
Excelchat Expert 08/07/2018 - 10:49
I just concatenated 3 IF functions
User 08/07/2018 - 10:49
is there any way to pull it as a series
User 08/07/2018 - 10:49
if i have an area looking at 8 cells it starts getting long
Excelchat Expert 08/07/2018 - 10:49
Excelchat Expert 08/07/2018 - 10:50
oh I understand, no, it must be done manually
User 08/07/2018 - 10:50
if my formulas were to b b1;b100 can i grab all of that at once
User 08/07/2018 - 10:51
i would want something like that but i just cant find a way to make it work
User 08/07/2018 - 10:52
=if(B4:B6<>0,
Excelchat Expert 08/07/2018 - 10:52
I think it must be done manually
Excelchat Expert 08/07/2018 - 10:52
e you need to have a condition for each cell
User 08/07/2018 - 10:52
bummer ok
User 08/07/2018 - 10:53
Excelchat Expert 08/07/2018 - 10:53
Excelchat Expert 08/07/2018 - 10:53
Have a good day
Excelchat Expert 08/07/2018 - 10:56
are you there??

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.