+ Reply to Thread
Results 1 to 4 of 4

Simple Intro Excel question (IF Statement?)

  1. #1
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Question Simple Intro Excel question (IF Statement?)

    Hello, I am trying to figure out how to make a "sum" (I Guess?) using IF statements. For example in sentence form, If B3 = "Red", +20. If B2 = "Sport", +40. These should be summed in the same box. So if the person drives a "Red" "Sports" car, then box should show 60, if just a red car, then 20. Thanks for your help, any help is appreciated!
    Last edited by loganc123; 02-02-2016 at 10:45 PM.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Simple Intro Excel question (IF Statement?)

    this would be one way... =IF(b3="red",20,IF(b3="sports",40,IF(b3="red sports",60,"")))
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    02-02-2016
    Location
    Orono, ME
    MS-Off Ver
    2013
    Posts
    21

    Re: Simple Intro Excel question (IF Statement?)

    Thanks Sambo, I appreciate your time. I seem to have figured that out, is there a way to get the IF Statement to return "0" rather than false if none of the statements apply?

    This is what I have currently
    =IF(H3="Sports",20,IF(I3="Red",15,IF(G3>0,G3*20,IF(F3>0,F3*5))))
    When I try to add a 0 after the 20, it says I have too many arguments.

    Also, here is a picture of my sheet.
    https://gyazo.com/bc4997cff1c1c0a48e6248b2cdd1fdf3

    Im showing the formula for R17, the result is 60, however the expected result should be G17*20 = 60, and then F17*5 = 35 so the total should be 95. Im thinking that Or is not the right solution here, maybe XOR? This is just counting the first condition it comes to.
    Last edited by loganc123; 02-02-2016 at 11:16 PM.

  4. #4
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Simple Intro Excel question (IF Statement?)

    I would add the zero here... =IF(H3="Sports",20,IF(I3="Red",15,IF(G3>0,G3*20,IF(F3>0,F3*5,0))))

+ 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. [SOLVED] Simple If statement question
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-27-2015, 12:28 PM
  2. Simple Intro
    By nicholson12 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 04-02-2014, 06:17 AM
  3. Simple Intro
    By shawnlarrabee in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 06-10-2012, 06:21 PM
  4. Simple Question - If statement
    By TShelt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2011, 01:44 PM
  5. Excel Simple question
    By Grunken in forum Excel General
    Replies: 1
    Last Post: 01-15-2009, 02:33 PM
  6. Simple if, than statement question
    By waternut in forum Excel General
    Replies: 1
    Last Post: 10-31-2006, 02:13 PM
  7. Simple Simple Excel usage question
    By BookerW in forum Excel General
    Replies: 1
    Last Post: 06-23-2005, 05:05 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