miscellaneous

Soooo, quick question.

i need help with a math formula in excel... any math genii (spelling?) out there who can help ?

im working out a pricing structure that works on a volume scale for e.g..

1 through 20 = 9.99 per item 21 through 50 = 8.99 per item 51 through 100 = 7.99 per item 101 through 150 6.99 per item 151 through 200 = 5.99 per item

would be nice for customers to just be able to enter the amount of items they want and for the approximate price to be generated automatically.

any help will be appreciated :)

PS: Hi everyone :)

love Flo

Oh man I just googled Genie, not what I was expecting, now I'm sad.

There are some pretty math wizards around here somewhere so i would expect help shortly.

Love, DNM

You can chain IF statements, looks like this works (where A1 is amount)

=IF(A1>150,"5.99",IF(A1>100,"6.99",IF(A1>50,"7.99",IF(A1>20,"8.99","9.99"))))

^ like that, but without the quotes i think, or it would be regarded as 'text' instead of numeric.

(and are you really going to send your customers excel sheets to fill in orders? And then what? They need to print it out and fax it to you? Or attach it to an email? Sounds like you're trying to make it do something it's not meant to do. How about a webshop?)

Sounds like you're trying to make it do something it's not meant to do

Sounds like a homework assignment to me ;)

Thanks for the replies :)

No its not to fill in orders or anything like that. I just want a simple application where a customer can type in the number of items he or she wants and it gives an estimate of the price.

for eg: "My name is Ivana Getsum and i want 274 items i wonder how much that would costs, hmm let me just type it in here in this little excel/or whatever and see"

so customers will receive a price structure sheet but to make there life easier i want them to be able to just insert the numbers and the cost calculated for them.

No this is not homework...its been a loooooong time since ive needed to do homework haha. Its just a personal project of mine and im going through the numbers to see if it will work. :)