Question about Excel (SS8SATAS5128400R)

# Nested IF functions in excel

I am writing a formula that can calculate a persons payable tax based on different tax brackets. I have so far:=IF(C6>6000,0.15%*(C6-6000),0) where C6 is the persons gross income and 6000-30000 is the first tax bracket the first part seems to work but when i add the second part:=IF(C6>6000,0.15%*(C6-6000),0),(IF(C6>30000,0.3%*(C6-30000))) ireceive an error message where am i going wrong?

Posted by on

• ppproduction Oct 29, 2007

10 bucks US for that I want my money back and I thought false values for If statements were optional

×

• Level 3:

An expert who has achieved level 3 by getting 1000 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

An expert that has over 10,000 points.

• Master

Hi,

Your first IF condition is “=IF(C6>6000,0.15%*(C6-6000),0)”

Where:

C6>6000 is your logical condition

0.15%*(C6-6000) would be the value if your logical condition is TRUE, and

0 would be the value if your logical condition is FALSE.

Your 2nd IF condition is “(IF(C6>30000,0.3%*(C6-30000)))”

Where:

C6>30000 is your logical condition

0.3%*(C6-30000) would be the value if your logical condition is TRUE, and

? would be the value if your logical condition is FALSE.

You are missing the value if it is FALSE.

Hope this be of some help/idea. Post back how things turns up or should you need additional information.

Good luck and kind regards.

Posted on Oct 26, 2007

• Louie Role Oct 30, 2007

Your query was "where am i going wrong?" and the response given was "You are missing the value if it is FALSE." based on the assumption that what you intend for the IF function to determine is the next value or condition (next tax bracket) and the alternate if not met.

Alternately, should you simply want the cell/result to state that C6 is not within the condition/bracket you specified, the formula should be:

=IF(C6>6000,0.15%*(C6-6000),0)=(IF(C6>30000,0.3%*(C6-30000)))
which will display "FALSE" if the condition of TRUE is not met.

Perhaps to better set your mathematical arguments right, you may want to replace the initial value of "0" and instead use a condition/formula that leads to another condition/formula if the initial condition is not met.

To be of further assistance, pls provide the tax brackets and with what % that you intend to use as well as different values for the
persons gross income, say about 5 of them.

With respect to the "
10 bucks US for that I want my money back", may I suggest that you take that issue with the admin of the site since I have no control over that.

×

## 1 Suggested Answer

Hi there,
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.

Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.

Here's a link to this great service

Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

Complete. Click "Add" to insert your video.

×

## Related Questions:

### How can I calculate the EMI of a business loan

Availing a Business Loan in Bangalore is a most benefitted opportunity for the entrepreneurs. It is good to know that now accessing the Business loan is more relaxed from the online lending marketplace Rupee Station. How is it? Find in the following points:

1. Rupee Station has a free EMI calculator tool where the borrower can use to get 100% accurate results through the end of theirs.

2. It is quite easy to use through the graphical representation by providing the also instant calculating results and brief about the loan repayment process as well.
Read More: Get Startup Work Loan in Bangalore
Rupee Station is the digital lending marketplace where you can avail the hassle-free financial support.

Feb 21, 2018 | The Computers & Internet

### I need a formula to calculate sales tax. the tax caps at \$300 dollars.

=IF((A1*7.5%) > 300, 300, A1*7.5%)
• IF Sales Amount * Tax Rate is greate than \$300 then make it \$300 no matter what the value is.
• IF Sales Amount * Tax Rate is less than \$300 then make it the value of Sales Amount * Tax Rate.

Sep 29, 2015 | Microsoft Office Excel 2003 for PC

### What taxes, if any, are included within a pro forma?

A pro-forma would usually include all the taxes that are payable by the vendor on behalf of the buyer. These are usually state sales taxes, or in some countries, may appear as a value-added tax (VAT) or goods & services tax (GST) applied as a percent markup of the transaction. The taxes included in a pro-forma should be those that apply to the transaction being taxed.

Is it a good? A service? A commodity, a major asset? Are there other fees & charges levied by local government that do not attract sales taxes?

It depends on what you are taxing, and in whose jurisdiction you are levying the tax and what rules apply to the calculation of the tax. Familiarise yourself with your applicable tax legislation.

Aug 31, 2014 | Microsoft Excel for PC

### What are the formulas in grading the grades uisng microsoft excel

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

1. All formulas begin with an equals sign (=).
2. Some formulas use operands such as +,-, *,/ for addition, subtraction, multiplication or division.
For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3.
3. Other formulas refer to different functions such as SUM, AVERAGE and others.
For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3.
4. Formulas can be combined with operands.
For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10.
5. Functions can be nested within each other.
For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

### How to calculate the percentage using the excel

Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?

Calculate the amount if you know the total and percentage For example, if you purchase a computer for \$800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

### I need help with a change of base formula problem.

It's simple here some logs:

log x base y = log x / log y
log (x*y) = log x + log y
log (x/y) = log x - log y
you just need to know that the default base of log in calculators is 10, so log x mean
log x base 10 = log x / log 10,
so write log x / log y for log x base y example:
log 8 base 2 = log 8 / log 2 that is how you write it on calculator, hope it was helpful

Jul 01, 2009 | Texas Instruments TI-83 Plus Calculator

### Formula for calculating the days beween months

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

### Multiple arguments in excel

Okay, here's a possible solution--based on my interpretation of your problem.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.

Nov 09, 2007 | Computers & Internet

### Excel argument

If I understand correctly, you want to figure the normal wages at 40 hours and less. If there is more then 40 hours, calculate the normal 40 hours, then calculate the hours overtime (time and a half) and add them to get a total.

B5 columns are filled with this:
=IF(A5>\$B\$1,(\$B\$2*\$B\$1)+((A5-\$B\$1)*(\$B\$3)),A5*\$B\$2)

NOTE: The \$ sign doesn't refer to money, it refers to an absolute reference so when copying a formula, the cell references with a \$ sign are fixed and don't adjust according to the relative position to where it's being pasted.

Oct 22, 2007 | Microsoft Excel 2003 (06503995)

#### Related Topics:

167 people viewed this question

## Ask a Question

Usually answered in minutes!

Level 3 Expert

Level 2 Expert