+ Reply to Thread
Results 1 to 5 of 5

If/Then Functions with formula in Excel.

  1. #1
    Registered User
    Join Date
    10-11-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    11

    If/Then Functions with formula in Excel.

    I have a spreadsheet that I use to track basic income and expenses for my wife's real estate business. Essentially I use the income and multiply by various tax rates for New York City, New York State, Federal, and Social/Medicare taxes. I use it to keep running tabs on how much tax money is owed to each (pre-deductions). I have made the formula and it works, however here is my question...

    I have a column called debit/credits. If its her paycheck, she selects "Debit" from the drop down. If its an expense, she selects "Credit" from the drop down. If its her paycheck, I want it to run the formula to show taxes on that check. If it is an expense however, I do NOT want that formula to run. I know I can do =IF(C4=Debit,"True","False"). Pretty much if C4 in the example is Debit I want it to run the equation and if its blank or Credit I want the cell to be blank.

    Ignore all you may know about taxes and deductions here, and just hang with me on the equation. I have other tabs and formulas that figure out deductions and the rest, so this is just a ball park idea for informational purposes! Thank you.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,417

    Re: If/Then Functions with formula in Excel.

    =IF(C4=Debit,value,value +/-tax calculation)


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-11-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: If/Then Functions with formula in Excel.

    Ok. So when I use a number it works but a word it does not. For example, if I said this...

    =IF(C4=1,equation,FALSE)

    ...Then the equation runs when 1 is in C4 and it says FALSE if anything else is in C4.

    If I change the equation to this...

    =IF(C4=1,equation,FALSE)

    ...Then the equation won't run. I tried changing the format of the cell to no avail. Any ideas?

    Thanks again.

  4. #4
    Registered User
    Join Date
    10-11-2012
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: If/Then Functions with formula in Excel.

    Nevermind, I figured it out. Thank you again.

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,417

    Re: If/Then Functions with formula in Excel.

    You're welcome. Thanks for the rep.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use excel formula functions?
    By clevelend in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-12-2013, 03:57 AM
  2. How to use excel formula functions?
    By Barneity in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-25-2013, 08:39 AM
  3. I need help in putting this formula all together using the excel functions
    By redvanilla91 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-19-2012, 11:23 PM
  4. Looking for Excel formula functions
    By kevin316 in forum Excel General
    Replies: 1
    Last Post: 11-18-2009, 04:41 PM
  5. [SOLVED] Why not nest more than 7 functions in Excel formula???
    By GrandCentral in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-31-2005, 08:33 PM

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