Click here to Skip to main content
15,891,607 members
Please Sign up or sign in to vote.
1.00/5 (3 votes)
See more:
=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
Posted
Updated 21-Mar-17 9:59am
v2
Comments
CHill60 21-Mar-17 10:30am    
What is the actual problem? Your question is not clear
[no name] 21-Mar-17 10:36am    
https://www.codeproject.com/Questions/1175387/I-used-the-nested-IF-function-and-it-dindt-wanted

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?
 
Share this answer
 
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.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900