0

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?

Feb 23, 2022 in Database 9,033 views

## 1 answer to this question.

1. Suppose a customer gets a 10 percent discount if he spends more than \$50. ...
2. The condition in this example is D5>=50. ...
3. The value_if_true in this example is calculated by multiplying D5 by 0.1 (in other words, calculating 10 percent of it).
• 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