Excel Magic Trick 828: Calculate Wholesale Price From Series Trade Discount (3 Array Formulas)
13.7 هزار بار بازدید -
13 سال پیش
-
Download Excel Start File:
Download Excel Start File: https://people.highline.edu/mgirvin/Y...
Download file: https://people.highline.edu/mgirvin/E...
Learn how to take the Trade Discount 20/10/15/10 as a text string and calculate the wholesale Price: (1-.2)*(1-.1)*(1-.15)*(1-.1)*NetCost with a single cell formula, 3 methods:
1. Text To Columns, then array formula using PRODUCT function, requires Ctrl + Shift + Enter.
2. MID and PRODUCT functions with array constant to create a formula that does not require Ctrl + Shift + Enter.
3. MID and PRODUCT and CHOOSE functions to create a formula that will work regardless of whether there are one, two, three, or four series Discounts
Download file: https://people.highline.edu/mgirvin/E...
Learn how to take the Trade Discount 20/10/15/10 as a text string and calculate the wholesale Price: (1-.2)*(1-.1)*(1-.15)*(1-.1)*NetCost with a single cell formula, 3 methods:
1. Text To Columns, then array formula using PRODUCT function, requires Ctrl + Shift + Enter.
2. MID and PRODUCT functions with array constant to create a formula that does not require Ctrl + Shift + Enter.
3. MID and PRODUCT and CHOOSE functions to create a formula that will work regardless of whether there are one, two, three, or four series Discounts
13 سال پیش
در تاریخ 1390/09/04 منتشر شده
است.
13,727
بـار بازدید شده