Formula to return value from multiple sheets if volume matched
I have a worksheet with average unit prices for <=50k,
<=100k,<=200k,<=300k,<500k and am creating a cover worksheet which will pull
the relevant unit cost based on the volume entered.
EG, I have a volume of 150k so I want the formula to take the price from the
<=100k sheet. I originally did the formula for sum(if xxx) but it added
each unit price instead of looking for the correct volume price.
Tried this but have an error - anyone able to help me ?
=if(IF(E8<=50000,'=50k pricing sheet'!AB7,IF(E8=199999,'=100k pricing
sheet'!I7,IF(E8=299999,'=200k pricing sheet'!I7,IF(E8=499999,'=300k
pricing sheet'!I7,IF(E8=500000,'=500k pricing sheet'!AB7))))))
|