+ Reply to Thread
Results 1 to 8 of 8

Help with an IF command

  1. #1
    Registered User
    Join Date
    03-07-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    4

    Help with an IF command

    This is my first post on the forum so please bear with me. I'm trying to use an IF command in excel but my excel knowledge peaked a few years ago when I got to pivot tables as I never really needed to use IF, VLOOKUPS or Macros.

    The attached spreadsheet is an income tax calculation. What I want to do is insert a formula in cell A12 that IF F9 is greater than or equal to 36,400 then A12=36,400 however if F9 is less than 36,400 then A12 is equal to F9.

    I hope that makes sense, any replies are appreciated.
    Attached Files Attached Files
    Last edited by censuspro; 03-07-2011 at 08:07 PM. Reason: UnSolved

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Help with an IF command

    Hi Censuspro

    Getting ready for your big day over there next week?

    No need for IF() function in this case - just use:

    =MIN(36400,F9)

    Oh, and you can stop using the + sign to start your formulas!

  3. #3
    Registered User
    Join Date
    03-07-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help with an IF command

    Quote Originally Posted by Cutter View Post
    Hi Censuspro

    Getting ready for your big day over there next week?

    No need for IF() function in this case - just use:

    =MIN(36400,F9)

    Oh, and you can stop using the + sign to start your formulas!
    Well everybody is broke so we'll see how many people turn out for the big day.

    That formula worked a charm. Thanks a million!

  4. #4
    Registered User
    Join Date
    03-07-2011
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help with an IF command

    Sorry to drag this up again but could you tell me the formula if I wanted to show in the attached spreadsheet that in cell A12 that if cell G9 was less than 72800 then A12 would be equal to 45400 plus the lower of the two incomes up to a max of 27400 (in this case 24000). However if both incomes are greater than 36400 then A12 is equal to 72800.

    I've typed in manually what the figures should be.
    Attached Files Attached Files

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Help with an IF command

    Maybe this in A12

    =IF(MIN(G7:G8)>36400,72800,45400+MIN(27400,MIN(G7:G8)))


    Taxes are fun - aren't they???

  6. #6
    Registered User
    Join Date
    09-11-2011
    Location
    Brownsville
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Help with an IF command

    I'm retired and haven't had a need to work often on Excel spredsheets, but I'm going nuts on what I perceived to be a very simple formula. Example as follows:

    Column A1 = 40
    Column B1 = 30

    Column C1 = I want the result in this column to read 1 if A1>B1 or 0 if A1<B1
    Column D1 = " "
    C1 should have a 1 or 0, C2 should have a 1 or 0 but C1 & C2 cannot have the same value obviously.

    I'm not familiar with using these function, tried MS help but my brain obviously is not processing like the machine computes. And maybe I should be using a different function.

  7. #7
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help with an IF command

    Hi, and welcome to the forum. Please note however your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

    PM me when you've done this and I'll delete this post.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  8. #8
    Registered User
    Join Date
    09-11-2011
    Location
    Brownsville
    MS-Off Ver
    Excel 2007
    Posts
    10

    Re: Help with an IF command

    Not sure what PM me means, please delete the post as I didn't realize I was making a post on someone's else's thread

+ Reply to Thread

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