我把这个代码用于excel，但它是#FOUT它的荷兰语所以使用谷歌翻译 [英] I used this code for excel but it sas #FOUT its dutch so use Google translate

问题描述

=IF(A1=8712100756818;"
ingredienten kruidige instant noedels met de smaak van kip Deegwaar 89,2% (noodles): 
TARWEBLOEM, palmvet, gemodificeerd aardappelzetmeel, zout, raapzaadolie, 
rijsmiddel (E500, E501), antioxidant (E306, E304). 
Kruidenmix 5,5%: Aroma (bevat TARWE, SOJA),
 suiker, zout, smaakversterker (E621, E635), sojasauspoeder 
(SOJABOON, TARWE, zout, moutextract, gistextract, palmolie), 
rode paprika, lente-ui, uipoeder, 
pepazer, antiklontermiddel E551 (nano), kleurstof E100, peterselie.
Oliemix 5,3%: Plantaardige olie (rijstvlies, SESAM), knoflookextract, 
sjalotextract, uienextract, gemberextract.";IF(A1=8712100750977;"
Ingrediënten: 
Deegwaarmix 83,7%: noedels 95,8% (TARWEBLOEM, tapiocazetmeel, 
palmolie, zout, stabilisator (E466, E451), rijsmiddel (E500, E501), sojasaus 
(SOJABOON, TARWE, zout)), gedroogde groenten 4,2% (maïs, wortel, prei). , 
Kruidenmix 10,5%: aroma (bevat SOJA), suiker, zout, smaakversterker (E621, E635), 
sojasauspoeder (SOJABOON, TARWE, zout, moutextract, gistextract, palmolie), 
chilipeper, uipoeder, peper, antiklontermiddel E551 (nano), 
kleurstof E100, peterselie. , Oliemix 5,8%: plantaardige olie (rijstvlies, SESAM), knoflookextract, sjalotextract, uienextract, gemberextract. , 
E=door de E.G. goedgekeurde hulpstof. 
Kan ei, melk, schaaldieren, weekdieren en vis bevatten. 
Allergie-informatie Bevat: tarwe, soja, sesamzaad, glutenbevattende granen. 
Kan bevatten: eieren, vis, melk, weekdieren.";"ongeldig product"))

这是代码



我尝试过的事情：



我尝试了几件事，但它没有工作所以任何人都可以帮助请

this was the code

What I have tried:

ive tried several things but it did not work so could anyone help please

推荐答案

我在我使用了嵌套的IF函数，它让dindt想要工作 [ ^ ]。你试过吗？

I gave you the answer to this problem in your original question at I used the nested IF function and it dindt wanted to work[^]. Did you try it?

当你问一个问题时，第一步是在你第一次发布这个公式时应用给你的解决方案。

第二步是陈述问题，最好与第一次不同。

When you ask a question, the first step is to apply solutions given to you the first time you posted this formula.
the second step is to state a problem and preferably, not the same as first time.

这篇关于我把这个代码用于excel，但它是#FOUT它的荷兰语所以使用谷歌翻译的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！