Hello all,
I'm trying to set up a formula as per the post subject relating to weight and price but with about 17 conditions per cell.
So I'm looking at:
If cell A1 is between 0 and 60 then show '32' in A4; if it's between 61 and 100 then show '49' in A4, if it's between 101 and 150 then show '68' in A4, etc, continuing on another 14 odd times until I reach the optimum weight / price combination!
Then I need to do the same for B1, C1, etc, all with the same criteria, to place the same pricing structure onto the next item.
Does anyone know how I can set this up as a formula, please? Or is there a better way to go about it?
All help appreciated.
Many thanks.
Neil.
I'm trying to set up a formula as per the post subject relating to weight and price but with about 17 conditions per cell.
So I'm looking at:
If cell A1 is between 0 and 60 then show '32' in A4; if it's between 61 and 100 then show '49' in A4, if it's between 101 and 150 then show '68' in A4, etc, continuing on another 14 odd times until I reach the optimum weight / price combination!
Then I need to do the same for B1, C1, etc, all with the same criteria, to place the same pricing structure onto the next item.
Does anyone know how I can set this up as a formula, please? Or is there a better way to go about it?
All help appreciated.
Many thanks.
Neil.