**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.*