Hey all,
I need to create a nested if statement for Excel.
This is what it would look like in a normal programming language:
I've been wracking my brain on this with no results. Help?
I need to create a nested if statement for Excel.
This is what it would look like in a normal programming language:
Code:
if (orders < 500)
cost=20;
else if (orders >= 500 && < 1000)
cost=18;
else if (orders >= 1000 && < 1500)
cost=16;
else if (orders >= 1500 && < 2000)
cost=14;
else if (orders >= 2000 && < 4000)
cost=13;
else if (orders >= 4000 && < 6000)
cost=12;
else if (orders >= 6000 && < 7000)
cost=12;
I've been wracking my brain on this with no results. Help?