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.

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

where E12 is subtotal

not sure if I am right?

Mar 23, 2022 in Database 535 views

## 1 answer to this question.

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.
• 23,260 points

## How do I perform an IF THEN statement in an SQL SELECT?

The CASE statement is the closest to IF in ...READ MORE

## Reading Excel File using Python, how do I get the values of a specific column with indicated column name?

So the key parts are to grab ...READ MORE

## How do I display a ratio in Excel in the format A:B?

Try this formula: =SUBSTITUTE(TEXT(A1/B1,"?/?"),"/",":") Result: A B ...READ MORE

## Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

Forget the PsychoPy complications for the time ...READ MORE

## In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

## Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE