J
Joe Peach
I know I should observe for a while before posting....but I did search, and
search, (unless I was using the wrong combinations of words) and found
nothing.
My question:
If you had a list of items, then the order #s, then the price you bought
them at...OK, so far I can do that, but the next column needed this type of
formula:
=the price bought times (X)...
And now there are details:
If the item is between 1 cent and $9.99 multiply by 3.25
If the Item is between $10.00 and $19.99 multiply by 3
If the item is between $20.00 and $50.00 multiply buy 2
There are 2 more amounts to put in...it is a 5 way equation...if something
is < then or > then.....
We have the Excel books, but since this is a new job, and I am overwhelmed
with other things, I thought some relating soul could point me in the right
direction...
Thanks way ahead...Joe
search, (unless I was using the wrong combinations of words) and found
nothing.
My question:
If you had a list of items, then the order #s, then the price you bought
them at...OK, so far I can do that, but the next column needed this type of
formula:
=the price bought times (X)...
And now there are details:
If the item is between 1 cent and $9.99 multiply by 3.25
If the Item is between $10.00 and $19.99 multiply by 3
If the item is between $20.00 and $50.00 multiply buy 2
There are 2 more amounts to put in...it is a 5 way equation...if something
is < then or > then.....
We have the Excel books, but since this is a new job, and I am overwhelmed
with other things, I thought some relating soul could point me in the right
direction...
Thanks way ahead...Joe