Excel - IF Function Problem - Expert Solution

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

i want to use a nested if function to check a cell for any value if not another one if no value another one and if the 3 cells has no value return blank
Solved by Z. D. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 12/08/2017 - 07:56
Hello and Welcome.
User 12/08/2017 - 07:57
no
User 12/08/2017 - 07:57
are you there
Excelchat Expert 12/08/2017 - 07:58
So for example, you want to check for a value in A1, if no value, then B1, if no value then C1, if no value then return a blank?
Excelchat Expert 12/08/2017 - 07:59
If there is value, should we return the value in that cell?
User 12/08/2017 - 08:00
yes and if in a1 has value that is the answer, if it is blank b1 and if bi has value that is the answer then c1 . and if aband c is blank blank
User 12/08/2017 - 08:00
yes
Excelchat Expert 12/08/2017 - 08:01
Take a look at the example I have put, The values to check for are in Cells A1, A2 and A3 and the result is in cell A3
Excelchat Expert 12/08/2017 - 08:01
Is this what you desire?
Excelchat Expert 12/08/2017 - 08:01
Can you test
User 12/08/2017 - 08:02
actually these 3 cells in 3 sheets
User 12/08/2017 - 08:02
i am goping to try
Excelchat Expert 12/08/2017 - 08:02
OK, its a minor modification, let me do it
Excelchat Expert 12/08/2017 - 08:03
For illustration purposes, I will put the values in cells A1 of sheets S1, S2 and S3
Excelchat Expert 12/08/2017 - 08:05
Can you see the updated example?
Excelchat Expert 12/08/2017 - 08:05
You can change values in cells A1 of sheets S1, S2 and S3
User 12/08/2017 - 08:06
i tried but the second cell value coming up instead the 1st cell if the 1st cel has value that should show
Excelchat Expert 12/08/2017 - 08:06
Did you see what I did?
Excelchat Expert 12/08/2017 - 08:07
cell A1 of sheet S1 has value 10
Excelchat Expert 12/08/2017 - 08:07
cell A2 of sheet S2 has value of 20
Excelchat Expert 12/08/2017 - 08:07
Sorry cell A1 of sheet S2 has a value of 20
Excelchat Expert 12/08/2017 - 08:08
cell A1 of sheet S3 has a value of 30
Excelchat Expert 12/08/2017 - 08:09
Now if I delete value of cell A1 in Sheet S1, you see the results in cell A3 of Sheet1 changes to S2 cell A1 value
User 12/08/2017 - 08:09
iti is ok now thank you
Excelchat Expert 12/08/2017 - 08:09
Entering Explanation Phase:
Excelchat Expert 12/08/2017 - 08:09
Do you understand the nesting of if functions?
User 12/08/2017 - 08:09
a bit
Excelchat Expert 12/08/2017 - 08:09
the formula is like this
Excelchat Expert 12/08/2017 - 08:10
=IF(test1,values if true, value if false)
Excelchat Expert 12/08/2017 - 08:10
in place of "value if false, we put another IF test
Excelchat Expert 12/08/2017 - 08:11
=IF(test1,value if true,IF(test2,value if true, value if false))
Excelchat Expert 12/08/2017 - 08:11
and we keep going like that
Excelchat Expert 12/08/2017 - 08:11
Do you know how to reference cells in different sheets?
Excelchat Expert 12/08/2017 - 08:12
To reference cell A1 in Sheet5 for example, its
User 12/08/2017 - 08:12
=IF('FSM Night'!F7<>"",'FSM Night'!F7,IF('FSM Afternoon'!F7<>"",'FSM Afternoon'!F7,IF('FSM Day'!F7<>"",'FSM Day'!F7,"")))
Excelchat Expert 12/08/2017 - 08:12
Good
User 12/08/2017 - 08:13
this is the formula i just converted your one into
Excelchat Expert 12/08/2017 - 08:13
Entering Discussion Phase:
Excelchat Expert 12/08/2017 - 08:13
Is it working now?
User 12/08/2017 - 08:13
yes thank you
Excelchat Expert 12/08/2017 - 08:13
No problem
User 12/08/2017 - 08:13
bye
Excelchat Expert 12/08/2017 - 08:14
Thank you and come back again
User 12/08/2017 - 08:14
ok i will

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.