IF function with function result as condition

andri witana

hi all;

=IF([Link SO]@row = "#NO MATCH"; "Tersedia"; "Terjual")

so i want to create this formula, if the condition cell contain "#NO MATCH" which is a result of INDEX function.

it always result in "#NO MATCH"

any input?

thx

update!..... edit

sorry all. plz ignore. i have found the solution

for those who found same problem, #NO MATCH is an error result

so combine any function with IFERROR function if you need to use the cell as reference of other cell formula

Find more posts tagged with

Accepted answers

andri witana

sorry all. plz ignore. i have found the solution

for those who found same problem, #NO MATCH is an error result

so combine any function with IFERROR function if you need to use the cell as reference of other cell formula

All comments

andri witana

sorry all. plz ignore. i have found the solution

for those who found same problem, #NO MATCH is an error result

so combine any function with IFERROR function if you need to use the cell as reference of other cell formula

Genevieve P.

Hi @andri witana

I'm glad you found a solution! The IFERROR function is a great idea for this. Thanks for posting what you found.

Cheers,

Genevieve

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.