Hi guys,
Would love to know if what I am trying to do it possible? Breakdown of what I'm looking to do is below.
Column D configures the markup percentage based on the value range that Column C falls within.
This range is on sheet 2 and contains the min. (A) and max. (B) range, as well as the corresponding percentage (D) that I'd like automatically added to Column D, sheet1.
For values under $2, I would like to add the value $2 (D) instead of a %
https://www.dropbox.com/s/znak0ujf28pa2yd/Garment Sales Price.xlsx?dl=0
Really looking forward to seeing if someone can help me configure this.
If there is a better way to go about this, I am totally open to ideas.
Thanks a tonne for your time!
Brian
Would love to know if what I am trying to do it possible? Breakdown of what I'm looking to do is below.
Column D configures the markup percentage based on the value range that Column C falls within.
This range is on sheet 2 and contains the min. (A) and max. (B) range, as well as the corresponding percentage (D) that I'd like automatically added to Column D, sheet1.
For values under $2, I would like to add the value $2 (D) instead of a %
https://www.dropbox.com/s/znak0ujf28pa2yd/Garment Sales Price.xlsx?dl=0
Really looking forward to seeing if someone can help me configure this.
If there is a better way to go about this, I am totally open to ideas.
Thanks a tonne for your time!

Brian