I used the nested IF function and it dindt wanted to work

Question

1.00/5 (2 votes)

See more:

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

Posted 8-Mar-17 20:13pm

Member 13047706

Updated 11-Mar-17 22:21pm

Patrice T

v2

Add a Solution

Comments

Michael_Davies 9-Mar-17 2:32am

Is cell A1 Text cell or General/numeric, try putting quotes round the value;

=IF(A1="8712100756818";....

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Richard MacCutchan · Answer 1 · 2017-03-08T21:53:00

Solution 1

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, $D$1, $E$1)

Where C1, D1 and E1 contain the different values.

Posted 8-Mar-17 21:53pm

Richard MacCutchan

Comments

Member 13047706 9-Mar-17 9:48am

so what do you mean with syntax

Richard MacCutchan 9-Mar-17 10:57am

What do you mean? That question makes no sense.

Member 13047706 11-Mar-17 14:07pm

im dutch and am not the best at english so pls explain

Richard MacCutchan 12-Mar-17 4:02am

See the Solution below.

Bryian Tan 9-Mar-17 11:50am

; should be ,

Richard MacCutchan 9-Mar-17 12:05pm

Yes, forgot to mention that. But my solution below is a much better way of doing it.

Richard MacCutchan · Answer 2 · 2017-03-09T05:20:00

Put the following value in cell C10:

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.

Put the following value in cell C11:

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.

Put the following value in cell C12:

ongeldig product

Put the following formula in cell C1:

=IF(A1=8712100756818,C10,IF(A1=8712100750977,C11,C12))

Note also the field separators in the IF statement are commas (,) not semi-colons (;) .

Patrice T · Answer 3 · 2017-03-11T22:21:00

VB

=IF(A1=8712100756818;"...",IF(A1=8712100750977;"...","ongeldig product"))

You have to make your mind, either you use "." as decimal separator and you use "," as parameter separator, either you use "," as decimal separator and you use ";" as parameter separator. You can't mix the two ways or writing.
Since you are in Netherlands, I suspect you need to write like this:

VB

=IF(A1=8712100756818;"...";IF(A1=8712100750977;"...";"ongeldig product"))

I used the nested IF function and it dindt wanted to work

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0