Tax Minus Function

My Texas Instruments calculator has a tax minus (tax-) key that I have used extensively in my business. I am a brand new Excel user and would like to know if there is a "formula" or "equation" that I can use to duplicate this on Excel.

Hi
If we calculate the difference between 2 dates (the normal minus function), excel gives us the exact number of days between 2
dates. By any function can we know the years, months and days separately like we manually do. Means between 10/01/1998 to
10/02/2002 can excel give 4 years, 1 month and 10 days??

Hello, I'm trying to create a formula where I can compare two cells but accept them as equal is one is plus/minus 0.1.
Example:
Cell A1 is 3, Cell A2 is 3.2, I want Cell A3 to turn red (or report "1")
Cell A1 is 3, Cell A2 is 3.1, I want Cell A3 to turn green (or report "0")

I need to write some sort of Excel construct (a function?) that will return the federal and state taxes that will be incurred
when I withdraw a specified level of spending money from my IRA. This sounds easy, except that the actual taxes incurred are
dependent upon the total amount of money that is withdrawn from the IRA--and this total amount includes both the spending
money and the money needed to pay the taxes. So computing the taxes cannot be done as a single calculation, but must use
some sort of iterative approach. Ideally I would like to start with a spending value, (SV), that would be the amount of
money that I want to spend in a year, not counting taxes. The function (or functions) would then go through some sort of
iterative calculation process that would compute the total spending level including taxes, (TS), the federal tax, (FT), and
the state tax, (ST). These values would have the relationship that TS=SV+FT+ST. When the iteration was finished, the
federal tax and state tax amounts would be consistent with the taxes that would be due for this level of total spending as
determined by the normal tax tables for both federal and state taxes. I am not concerned that the tax figures be absolutely
exact, so a lot of iteration is probably not necessary. Any recommendations for how I might best do this?

I need to do some further
analysis with the data in column C, but because it returns as a #Value, I can't do them. I need the data in Column C to
either be numerical or #N/A N/A. I know that if I use =SUM(A2,B2) my data in C3 will return the value in A2 (93.707), but
i need to do a subtraction. There is no DIFFERENCE or MINUS function (similar to SUM) that I'm aware of and I can't
multiply column A or B by -1 as this will still return #Value as an answer in Column C. any ideas on how i can achieve the
results i'm looking for? i've put the answer in parenthesis for waht i'm trying to achieve.

Here's the outline. I have been told to use this to calculate tax: When calculating the tax, assume
that the monthly gross profit taxed @ 20% for the first $20,000 then 30% for the remainder of gross profit.

The
monthly gross profit is $20,153 (C14) and the tax table (table7) is below:

Taxable Income
Fixed Tax
Marginal Tax Rate
0
0
0.2
20000
3999.8
0.3
I don't know how to calculate the 20% of the first $20,000.

This is what I have done for the fixed rate:
VLOOKUP(C14,Table7,2,TRUE) which gave me 3999.8

and for the 30% of the remainder ($153) I did:
(C14-VLOOKUP(C14,Table7,1,TRUE))*VLOOKUP(C14,Table7,3,TRUE) which gave me 45.90

Is there a simpler way to do all
this? And can IF function be used along with VLOOKUP at all? Thanks in advance

Faye

Additional info: I
also need to allow the formula to show an operational loss (i.e. profit < $0), what does that mean?
Note: All formulae must contain VLOOKUP.

The PMT function should work just fine, with a couple of caveats. Assuming
you've set the number of payments (NPER) to the number of months, you need to
adjust your interest rate accordingly (eg: not 6%, but 6%/12). You'll also
want to put a minus sign on the PV argument. Ex: a 30 year loan at 6.5% for
$145000: =PMT(6.5%/12,360,-145000). If you can't get the function to behave
as you expect, post the terms and the formula you're using. (Also, remember
that your total payment will probably include taxes and insurance, which
won't be captured in this formula).
--Bruce

"JSEVonda" wrote:

> Does anyone have a function to calculate a amortized mtg payment. I tried
to
> use the pmt function, and it came out all wrong. Have tried many different
> iterations of the numbers, and they still do not come out to be same as my
> Loan Officer Point software indicates the answer should be.
>
> I need to put this function calulation in an excel spreadsheet.
>
> Thanks

The PMT function should work just fine, with a couple of caveats. Assuming
you've set the number of payments (NPER) to the number of months, you need to
adjust your interest rate accordingly (eg: not 6%, but 6%/12). You'll also
want to put a minus sign on the PV argument. Ex: a 30 year loan at 6.5% for
$145000: =PMT(6.5%/12,360,-145000). If you can't get the function to behave
as you expect, post the terms and the formula you're using. (Also, remember
that your total payment will probably include taxes and insurance, which
won't be captured in this formula).
--Bruce

"JSEVonda" wrote:

> Does anyone have a function to calculate a amortized mtg
payment. I tried to
> use the pmt function, and it came out all wrong. Have tried many different
> iterations of the numbers, and they still do not come out to be same as my
> Loan Officer Point software indicates the answer should be.
>
> I need to put this function calulation in an excel spreadsheet.
>
> Thanks

What function or calculation could I use in a spreadsheet to calculate the
price of an item minus the local sales tax so that in the end the final
price would be a whole number. I would like to enter the local tax rate in
percent so I could figure out what the price for an item should be so in the
end the final price is $5, $10, $15 etc. Using Excel 2000.

I am currently working on a project that requires me to get the total number of business days between two
dates. I have used the NETWORKDAYS function and it works great. However, I need a formula (if their is one) that will give
me the total number of business days between the dates and either A) minus 1 from the total or B) not include the first day
as an actual work day.

example.

Start date - 3/20/12
End date - 3/23/12
Total number of business days minus 1 = 3

I can do this if i use the function, copy and paste special and then
create another row next to the total and do a =A1-1 all the way down but was just wondering if their was an easier way.

I am currently adding a macro to add a function to my BulkQuotesXL package. What I am trying to do is after my AnalyzerXL
package gets the quotes for my stocks I am trying to calculate the min value from my Low column and a max column from my High
Column. Once the calculation is done I like to mark the low number as red and the high number as green. Than put the
determined value for high in column G and the determined value for low in column H. Once this is done I would like to
subtract the first high value from the first low value. Put that value in the I column. My current formula for determining
the low value is If LowM2 < -0.15 And LowM1 < 0.08 And LowP1 > 0.05 And LowP2 > -0.1 Then
this is not working correctly so realize I have a flaw in my logic any help would be appreciated . I have been thinking of
using the application.worsheet.min function but I don't really understand how to set that up.

I am trying to show the status of the task completion by using IF function. I have the focus and actual
columns in my worksheet. The focus is formatted as date, and the actual is date or percentage (if it is date or 100% then
mean that the task is completed). The result which i am looking for is as below:

- If Focus is blank then it would
show nothing in the Status
- If Actual is 100% or any date then it would show DONE the Status
- If Focus is smaller than today date then it would show OVERDUE in the Status
- If Focus minus today date is smaller than 8 then it would show TO FINISH IN 7 DAYS in the Status

The enclosed
attachment is my sample worksheet. Please kindly advise.

A similar question was post
http://www.excelforum.com/excel-gene...ml#post2526109

1.
row 17 needs to: equal row 3 until row 3 hits a value>0
2. following the first entry in row 17 the next cell must equal the previous cell minus the cell below that one eg:
f17=E17-E18
3. this all needs to be in one formula!

I would like to create a VBA function that calculates federal and state income taxes. I know how to do this in Excel using a
table, but I do not want to put the calculator in an Excel spreadsheet. Instead I want the data (i.e., the tax tables) to be
in the VBA macro that I can access as a function in any spreadsheet. I would think that I would need an array, and a loop of
some kind. I'd like to be able to enter the tax table easily into the VBA macro. I think that the arguments of the tax rate
table are taxable income, filing status and year. I've got to believe that this has been done before -- I did it many years
ago in BASIC but i forgot how to do it. I remember that I would type in a line that would be something like
(7,825,31,850,.15,782.50) and the program would look at the taxable income. If it were between (in this example) $7,825 and
$31,850 it would take the taxable income, subtract $7,825 from it, multiply that by .15 and add 782.50. That would be the
function's result. If the taxable income were greater than $31,850, it would go to the next line, which would also be four
numbers representing the parameters of the next tax bracket. Do you know where either I could find sample code that I could
adapt, or could you provide more guidance on how I write the code myself? Thanks.

I'll get straight to the point. I have a n number of rows with 3 columns: Date, Tax, Value. My
objective is to have my code loop throught the rows and sum a monthly amount of tax collected. I need to do this for the
entire year. Now I don't think rewritting the loop 12 times is the most efficient way of doing this. Also, I need to have the
count and the sum reset after the loop is done. Is there a simpler way of doing this? I'm thinking this coudl be done with a
function and some defined variables at the beginning, but i'm not sure.

I have a issue. I have a date that is save as a date variable. Is there any quick functions that can be used in VBA that
will get a date split by tax year.

For Example

If I was wanting to look at tax year 06 this would be
from April 06 to March 07. The year would have to be determined by a entered year Input box.
After it has been split by year I then if it falls between the dates to split the date by Month. Is there any simple
functions and comparitors I can use on a date defined variable.