Question about Microsoft Excel for PC
How do I write a formula that will do the following - If taxable income is:
$0-$6000, tax is nil.
$6,001 - $21,600, tax is 17c for each $1over $6,000.
$21,6001 - $58,000, tax is $2,652 plus 30c for each $1over $21,6000.
$58,001 - $70,000, tax is $13,572 plus 42c for each $1over $58,000.
Over $70,001, tax is $18,612 plus 47c for each $1 over $70,000.
So, if I work on $69,6000 as taxable income,....Help!
Here you go!
1) Cell A8 mentioned here can be changed according to the cell where you want the input.
2) Change the Cell Formatting of the input and output cell to Currency so that you can see the $ symbol.
Please let me know if you have any more queries
All the Best.
Was this solution helpful? Show your Appreciation by rating it:
Posted on Feb 22, 2008
a 6ya expert can help you resolve that 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.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Sep 29, 2015 | Microsoft Office Excel 2003 for PC
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
Jun 09, 2010 | Microsoft Office Professional 2007 Full...
Dec 19, 2008 | Microsoft Excel for PC
Dec 02, 2008 | Microsoft Excel for PC
Sep 29, 2008 | Microsoft Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
134 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: