So I have this spreadsheet with responses from a Google form.
I want column I to be filled in only when it is a different input than the standard countries they get to choose from.
How can I do this?
thank you in advance!
So I have this spreadsheet with responses from a Google form.
I want column I to be filled in only when it is a different input than the standard countries they get to choose from.
How can I do this?
thank you in advance!
Last edited by Yazmin9240; 06-17-2021 at 09:41 AM.
=IFERROR(IFS(A2="The Netherlands","",A2="Belgium"," ",A2="Germany","",A2="Great Britain","",A2="Poland","",A2="Switzerland","",A2="Austria",""),A2)
Could also do IFSNOT but this is easy enough to have the error copy it.
I believe this is what you are asking but the spreadsheet and information you provided was very confusing.
Last edited by Zaerick; 06-17-2021 at 09:50 AM.
Using =IFS may be what you need, allows for multiple criteria.
But your file is not very clear what you expect.
Can you Provide expected result sample in the file?
If you find the suggestion or solution helpful, please consider adding reputation to the post.
Thanks a lot!
It worked!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks