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?
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
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.
×
Aug 31, 2014 | Microsoft Excel for PC
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.
Aug 19, 2011 | Microsoft EXCEL 2004 for Mac
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.
Apr 30, 2011 | Computers & Internet
Jul 01, 2009 | Texas Instruments TI-83 Plus Calculator
Aug 25, 2008 | Microsoft Office Professional 2007:...
Nov 09, 2007 | Computers & Internet
Oct 22, 2007 | Microsoft Excel 2003 (06503995)
Sep 06, 2017 | Excel (SS8SATAS5128400R)
182 people viewed this question
Usually answered in minutes!
10 bucks US for that I want my money back and I thought false values for If statements were optional
×