11/18/2023 0 Comments Excel discount formula![]() ![]() After that, press the ENTER button and you will see the discounted price for Gingerale because it’s a liquidįinally, using Excel If Function, you will get the discount prices for the products based on their type.If the product is not liquid, there will be no discount. The RIGHT Function here helps to make the condition with the character ‘ (Liquid)‘. ![]() Here, the formula will show you the discounted price of the product in C5 if it meets the desired condition. ![]() Tag that product with (Liquid mark), make a column for the discounted price and type the following formula in cell D5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |