Formula in MX Excel 2010

Posted on 2012-08-27
Last Modified: 2012-08-29
Need help creating a formal that will enter a value when a specified word in entered.

For example: If H2 = interviewing,  if true then I2 needs a value of 3. If false then J2 needs a value of 0.
Question by:Lbello
    LVL 39

    Accepted Solution

    put in I2
    in J2

    LVL 16

    Expert Comment

    What nutsch says will work, but I have a couple of questions.
    (1) Is the word Interviewing going to be written like that? or perhaps it will be in caps, lower case or mixed characters?
    In this case you should use the UPPER function to ensure all instances / writing of Intervieweing are catered for.
    IN I2
    IN J2

    (2) What happens in cell I2 if H2 <> interviewing?
    Should it be blank like the function above or you need something more indicative? ie a "-"

    (3) What happens in cell J2 if H2 = interviewing?
    Should it be blank like the function above or you need something more indicative? ie a "-"

    Author Comment

    Interviewing will appear on the spreadsheet as is.

    Author Closing Comment

    Worked like a charm.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now