Excel Magic Trick 828: Calculate Wholesale Price From Series Trade Discount (3 Array Formulas)
Автор: excelisfun
Загружено: 2011-11-25
Просмотров: 14135
Описание:
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
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
