Find Discount % and Discount Value for Actual Sales that are higher or equal to Target Sales

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”)

YouTube video

#mindstormGR #discount