Formula for Deliveries!

[DanielBellfield]

I want to work out a formula that can read a quantity from one cell and work out delievery costs for the items dependant upon the number in that cell providing a dicount for certain numbers:

1 item = 80
2-5 = 50
5-10 = 30
10+ = manual price required.

help?

 

[DanielBellfield]

Is it possible to insert a formula before that one to work off an if basis:

E.G.

=IF(F14=Y,CONTINUE,STOP)IF(C11>=11,"Manual Input Required",A1*LOOKUP(A1,{1;2;6},{80;50;30}))

?

 

[T. Valko]

Is it possible to insert a formula before that one to work off an if basis:

E.G.

=IF(F14=Y,CONTINUE,STOP)IF(C11>=11,"Manual Input Required",A1*LOOKUP(A1,{1;2;6},{80;50;30}))

?

Maybe this...

=IF(F14="Y",IF(C11>=11,"Manual Input Required",A1*LOOKUP(A1,{1;2;6},{80;50;30})),"")

 

[DanielBellfield]

Supa Dupa! :P

Works a treat! Thank you!

 

[T. Valko]

Supa Dupa! :P

Works a treat! Thank you!

You're welcome. Thanks for the feedback!