# calculate using IF function when buyer gives 1% discount if payment over 300000 The Power of the IF Function in Calculating Discounts

The Power of the IF Function in Calculating Discounts

The IF function is a powerful tool in Microsoft Excel that can be used to make calculations based on logical tests. This function is particularly useful in the context of calculating discounts when a buyer pays more than a certain amount. For example, when a buyer pays more than \$300,000, they may be eligible for a 1% discount. With the IF function, this calculation can be automated, saving time and ensuring accuracy. The IF function begins with the syntax “IF(logical_test, [value_if_true], [value_if_false]).” This means that the function will first evaluate the logical test, which can be a value, formula, or comparison operator. If the logical test is true, the value specified for “value_if_true” will be returned. If the logical test is false, the value specified for “value_if_false” will be returned. In the context of calculating discounts, the value_if_true would be the discounted amount, while the value_if_false would be the amount without the discount (Ahmed, 2020). For example, if a buyer pays \$400,000, the following formula can be used to calculate the discounted amount: IF(A2>300000, A2*0.99, A2). This formula will return the value of. Cont…

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.