We must explain to you how all seds this mistakens idea off denouncing pleasures and praising pain was born and I will give you a completed accounts off the system and expound.
Find Discount % and Discount Value for Actual Sales that are higher or equal to Target Sales given by your Suppliers.
Use functions IF and VLOOKUP.
Formula for cell H4 (Discount %)
=IF(E4>=G4;”Discount “&VLOOKUP(F4;$M$4:$O$13;3;FALSE)*100&”%”;”No Discount”)
Formula for cell I4 (Discount Value)
=IF(E4>=G4;VLOOKUP(F4;$M$4:$O$13;3;FALSE)*E4;”No Discount”)
quick contact
You can help customers in real-time across all of your channels from email, social, website, iOS, and Android apps.