Hello Experts,
Hope you could assist me with this. Please look at attached with my description.
Situation
I'm trying to look a value in column A (A17 to A21) and determine the dollar value after discount (desired result in column C. C17 to C21)
Example
cell A17, product 'h.3' is categorized hardware. Thus it'll take the price multiply by the desired discount percentage (F1),
cell A18, product 's.1' is categorized software. Thus it'll take the price multiply by the desired discount percentage (F2),
cell A19, product 'nd.2' is categorized as non discountable item. Thus it'll just take the price as is.
Bookmarks