Confusing combination of cell references and the IF function

[MisterGB]

Hi,

I am in a bit of a pickle. I am currently completing some exercises to learn excel. The current function in question is the IF function along with its logical operator friends IF(OR and IF(AND.

The document is in Dutch, but I have translated the instructions if I need to share the document somehow to make it make sense for you guys.

Below is the task:
--------------------------------------------------------------------------------------------------------

If the total cost inclusive BTW (G26) is smaller than 500 euros and the total number of pieces (C23) is at least 10 (E5), then they receive a biro (balpen, G5).

For total costs of more than 600 euros (F5), but also if the total number of pieces is more than 50 (E7), then they receive a radio (G7).

In all other situations they receive a timepiece (uurwerk, G6).

CONDITIONS
- This all needs to be put into one formula in cell D8 using IF, IF(OR, IF(AND.
- We may only use cell references and thus no manual input.
--------------------------------------------------------------------------------------------------------

These my completed formulas that I have tried:

=IF(AND(C23>=E5,G26<f5),g5,"")&if(or(g26>F6,C23>E7),G7,"G6")

</f5),g5,"")&if(or(g26>or

=IF(AND(C23>=E5,G26<f5),g5,"")&if(or(g26>F6,C23>E7),G7,"")&IF(NOT(AND(C23>=E5,G26<f5,g26>F6,C23>E7)),G6,"")

Original in Dutch: =ALS(EN(C23>=E5;G26<f5);g5;"")&als(of(g26>F6;C23>E7);G7;"")&ALS(NIET(EN(C23>=E5;G26<f5;g26>F6;C23>E7));G6;"")

</f5;g26></f5);g5;"")&als(of(g26>My formula works fine until I need to add the "In all other situations they receive a timepiece" part which is the entire of IF(NOT or simply G6. In both cases I end up with "balpenuurwerk".

Sorry for the horrifically long post and thank you in advance.

MisterGB

[TABLE="width: 402"]
<tbody>[TR]
[TD="colspan: 6"][/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]

</f5,g26></f5),g5,"")&if(or(g26>

 

[MisterGB]

Res for image if I can get it to work.

​

 

[MisterGB]

Solution found: I had to nest the IF functions at the point where the action for a FALSE was required. I just learned to nest properly!