Excel - IF Function Problem - Expert Solution

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

i need a foumal that sounds like this =If(A1="XX",B1,"")But if A1="" then i want it to go down one cell and preform the same function
Solved by A. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/08/2017 - 09:35
Welcome, Thanks for choosing Got It Pro-Excel
Excelchat Expert 22/08/2017 - 09:35
I’m happy to be able to help you today
Excelchat Expert 22/08/2017 - 09:35
How may I help you today?
User 22/08/2017 - 09:35
i need a fourml
User 22/08/2017 - 09:35
can i show you in this
Excelchat Expert 22/08/2017 - 09:36
the formula if a1="" is same with if
Excelchat Expert 22/08/2017 - 09:37
where you want to apply the formula
Excelchat Expert 22/08/2017 - 09:37
in column d
User 22/08/2017 - 09:38
this looks good
User 22/08/2017 - 09:38
but
Excelchat Expert 22/08/2017 - 09:38
when you move one row down
User 22/08/2017 - 09:38
if A1 does not = XX
Excelchat Expert 22/08/2017 - 09:38
ok
User 22/08/2017 - 09:38
then move to a2
User 22/08/2017 - 09:38
and if a2 does not = XX move down
User 22/08/2017 - 09:39
i have the foumal in another sheet same workbook
Excelchat Expert 22/08/2017 - 09:39
you want value in b when a = xx
User 22/08/2017 - 09:40
yes
Excelchat Expert 22/08/2017 - 09:40
and the result appear just in d1
User 22/08/2017 - 09:41
yes
Excelchat Expert 22/08/2017 - 09:41
add more value in b
Excelchat Expert 22/08/2017 - 09:42
you want xx
User 22/08/2017 - 09:43
only when its XX
Excelchat Expert 22/08/2017 - 09:43
Alright, please give a moment to solve your problem. Thank you!
User 22/08/2017 - 09:43
thank you
Excelchat Expert 22/08/2017 - 09:52
go to link
Excelchat Expert 22/08/2017 - 09:53
https://docs.google.com/spreadsheets/d/1zSoHIlgOCP8G-ddlfb5fbl3ANvkmxj8xsJiKZLwWX2Q/edit?usp=sharing
Excelchat Expert 22/08/2017 - 09:53
go to this link to end solve
Excelchat Expert 22/08/2017 - 09:53
ok
Excelchat Expert 22/08/2017 - 09:53
escalate
User 22/08/2017 - 09:54
?
Excelchat Expert 22/08/2017 - 09:54
complete solve in spreadsheet
Excelchat Expert 22/08/2017 - 09:54
go with google sheet

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.