add x euros every 1000 units

[nystagmenos]

Hello. I am trying to make a function where.
I have a product that costs every 1000 units 4 euros.
So 1000 units cost 4 euros. 2000 units 8 euros etc.
I tried it with ifs but too many arguments till i reach to 1.000.000 lets say or more.

Is there a more easy way to do this?

 

[Joe4]

What if you have 1500 units?
Would it be 4 euros or 6 euros?

I am just trying to figure out if it really jumps only in increments of 4 euros, or can do partials.

If in increments of 4 only, use this formula for a value in cell A2:

=INT(A2/1000)*4

If partials, use:

=INT(A2/250)

 

[nystagmenos]

fantastic mate. Let me ask you something else. There are no partial numbers for begin with. I want a starting price up to 3000 units. So the price is up to 3000 units 50 euros and then add 4 euros every 1000 units. Thank you again.

 

[saboh12617]

Hello,

If I got it correctly, i think the formula below gives you the expected result

=INT(MAX(0, A2-3000)/1000)*4+50

 

[Joe4]

Do you mean something like this?

If that is the case, then the formula would be:

=50+MAX(INT((A2-3000)/1000)*4,0)

 

[nystagmenos]

YES. This is it. Thank you very much.

 

[Joe4]

You are welcome.
Glad we were able to help!