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.
