Results 1 to 3 of 3

If a cell is between two numbers then it equals...

Threaded View

  1. #1
    Registered User
    Join Date
    05-11-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    10

    If a cell is between two numbers then it equals...

    Hey guys, I have two sheets, one with fillable data and the other is the spreadsheet with the results of the data.

    My spreadsheets are for a hypothetical business, and have 10 years of info in the results sheet. They vary greatly by the figures I put into the fillable data sheet.

    I have projections for ten years of profits and want to add a tax cell for each year . See Below:

    if taxable income is over but not over tax is plus % of amount over
    $0 $17,850 $0.00
    +
    10.00% $0.00
    $17,850 $72,500 $1,785.00 + 15.00% $17,850

    and it goes on for a few more brackets.

    I would like add a self generating figure to see how much taxes I would pay in a tax cell using the info from profits and tax rate cells.

    Any ideas?

    Thanks guys
    Last edited by travistea; 05-30-2013 at 07:08 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1