Formula problem

  • Thread starter Thread starter bj
  • Start date Start date
B

bj

A B C D E
F G H
A7402P 1 5 34.9 31.4 28.25 0 0
A7402P 6 11 34.9 31.4 28.25 0 0
A7402P 12 999999 34.9 31.4 28.25 0 0




I have a problem that I cant work out who to do. Ive tried many nested if
statments without any luck.

Basically I have this spreadsheet above full of pricecodes(Col A), Quantity
Breaks (Col C, D) and prices (Col D, E , F, G, H)


In Col I Im trying to enter a formula that will place the price in one
column with their appropriate price breaks.

For the example above the first cell in Col I should be $34.90 then $31.40
then $28.25 (Thats my aim)

Only problem is some pricecodes have only one price break and others can
have upto 5.

The one constant is that all pricecodes have a minimum of 1 and a maximum of
999999


Can anyone out there help me how I would do this?

Thanks in advance.
 
You have not uniquely defined what you want to happen. Two possible
interpretations are:

- Copy D1:H3, select I1, and on the menu choose
Edit|Paste Special|Transpose (possibly also clicking Values)

- =OFFSET($D$1,INT((ROW()-1)/5),MOD(ROW()-1,5))

Jerry
 
Back
Top