我使用了嵌套的IF函数，并且dindt想要工作 [英] I used the nested IF function and it dindt wanted to work

问题描述

这是我的代码，它是我的学校项目的noodels成分列表

this was my code its a list of ingredients of noodels its for my project of school

=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"))

所以它是荷兰语，所以你知道



我尝试了什么：



我试图解决它，但我找不到错误

so it is in dutch just so u know

What I have tried:

ive tried to solve it but i could not find the mistake

推荐答案

要做的第一件事是删除所有无关的细节并创建一个简单的 IF 表达式，它可以正常工作，使用几个简单的字符串值，所以你可以看到语法是正确的。一旦工作，你可以用较长的值替换简单的值。虽然更好的想法是将不同的数据值放在固定的单元格中，只是引用不同的单元格在 IF 表达式中。



类似于：

The first thing to do is to remove all that extraneous detail and create a simple IF expression that does work, using a few simple string values so you can see that the syntax is correct. Once that is working you can replace the simple values with the longer ones. Although a better idea is to put the different data values in fixed cells and just refer to the different cells in your IF expression.

Something like:

=IF(A1=8712100756818,

C

1，IF（A1 = 8712100750977，

1, IF(A1=8712100750977,

这篇关于我使用了嵌套的IF函数，并且dindt想要工作的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！