Hello there,
I can problems to figure out how to write nested if function correctly.
Tried many variations and still no result.
I need to create a formula like this:
If sales are more then 12000 EUR, write 900
If sales are more then 16000 EUR, write 1100
If sales are more then 20000 EUR, write 1300
If sales are more then 24000 EUR, write 1400
Tried all variations and cannot work it out.
Please help