Hi All -
I currently have a very long and complicated formula that i am positive can be made more simple but just not sure exactly how to accomplish it. I have a table of products, max price, min price, and average as shown below in one tab of an excel
<tbody>
</tbody>
In another tab I have products and prices listed that may fall within the range or without. If it falls within the range for that specific product then i want to use the price shown. If it falls outside of the range then i want to use the average.
<tbody>
</tbody>
Can someone help me with this or point me in the right direction of what type of formula i shoud use?
THanks so much!
****** id="cke_pastebin" style="position: absolute; top: -3.8147e-06px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody></body>
I currently have a very long and complicated formula that i am positive can be made more simple but just not sure exactly how to accomplish it. I have a table of products, max price, min price, and average as shown below in one tab of an excel
ColumnA | ColumnB | ColumnC | ColumnD | |
Row1 | Product | Max | Min | Average |
Row2 | productA | $2.00 | $1.00 | $1.50 |
Row3 | productB | $5.00 | $1.00 | $3.00 |
Row4 | ProductC | $10.00 | $20.00 | $15.00 |
<tbody>
</tbody>
In another tab I have products and prices listed that may fall within the range or without. If it falls within the range for that specific product then i want to use the price shown. If it falls outside of the range then i want to use the average.
ColumnF | ColumnG | ColumnH | |
Row6 | Product | Price | Price New (adjusted based on above) - this is where i need to adjust my formula |
Row7 | productA | $1.05 | $1.05 |
Row8 | productA | $3.00 | $1.50 |
Row9 | productB | $2.75 | $2.75 |
Row10 | productC | $5.00 | $15.00 |
<tbody>
</tbody>
Can someone help me with this or point me in the right direction of what type of formula i shoud use?
THanks so much!
****** id="cke_pastebin" style="position: absolute; top: -3.8147e-06px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
ColumnA | ColumnB | ColumnC | ColumnD | |
Row1 | Product | Max | Min | Average |
Row2 | productA | $2.00 | $1.00 | $1.50 |
Row3 | productB | $5.00 | $1.00 | $3.00 |
Row4 | ProductC | $10.00 | $20.00 | $15.00 |
<tbody>
</tbody>