How to use IF and AND Function Together in Microsoft Excel | GOOD FOR BEGINNERS
HTML-код
- Опубликовано: 26 май 2018
- In this Microsoft Excel tutorial you will learn how to create a simple IF and AND function TOGETHER that will allow you to apply a specific rebate based on the supplier AND the volume
Add me on Linkedin: / pandimengri
What if I had multiple payout tiersfor certain product quantities sole (i.e., 1001-10000 tons sold) Customer gets $4 over 10001Customer gets $5 etc. Could I just do a IF AND for all the critieria I need in regard to quantity and $ payout?