how do I calculate discount with if function in excel

Question

I got this question in excel,

The discount is to be computed as follows: (1) No discount for the first $100. (2) For subtotals above $100, five percent of the amount that the subtotal exceeds $100. (3) For subtotals above $500, the afore-mentioned discount plus an additional five percent of the amount that the subtotal exceeds $500. The discount should be applied to the subtotal of all products (not the per-product total price).

The discount must be computed using a single formula that will work correctly regardless of how big the subtotal is. All decision-making about the discount, based on the size of the subtotal, must be done automatically by the formula (using the IF function), NOT by you, the human user.

My answer to it was

=IF(E12>=100,E12*5%,E12*0%)+IF(E12>500,E12*5%,E12*0%)

where E12 is subtotal

not sure if I am right?

Answer 1

Notes about the release; Frameworks to aim for. EPPlus 4.0.5 is the latest version of EPPlus. For the most up-to-date information, go to epplus.codeplex.com. EPPlusCreate Advanced Excel Spreadsheet is a spreadsheet created by EPPlusCreate. There are some new features.

I'm trying to figure out which of the cell values in an excel file are date values. Now I tried it with Apache POI SS User's getCellType.

We can rapidly discover and highlight duplicate and unique values in a given cell range using Excel conditional formatting. We're going to go in this article.

Features. Github. EPPlus is a pure.NET package that allows software developers to read, create, and export OOXML Excel 2007/2010 files.