Hello everyone!
I received great assistance from this site earlier this year, and I'm hoping that you will be able to assist me once again .
This is the link to the old thread. I have been using this formula and it works perfectly. This formula looks at the origin worksheet. It looked for specific length, and markup by origin type. On the inventory worksheet, the formula found the type of hair and calculated the price based on length and total weight.
For some reason, if I change the markup for the cambodian items. The price doesn't change. I notice that if I change the markup for Chinese, it does change. I believe the calculation isn't working as designed. Can someone please review and assist?
View attachment PHE Pricing.xlsx
@NBVC
I received great assistance from this site earlier this year, and I'm hoping that you will be able to assist me once again .
This is the link to the old thread. I have been using this formula and it works perfectly. This formula looks at the origin worksheet. It looked for specific length, and markup by origin type. On the inventory worksheet, the formula found the type of hair and calculated the price based on length and total weight.
For some reason, if I change the markup for the cambodian items. The price doesn't change. I notice that if I change the markup for Chinese, it does change. I believe the calculation isn't working as designed. Can someone please review and assist?
View attachment PHE Pricing.xlsx
@NBVC