IF THEN Formula Statement

Discussion in 'Word Tables' started by meimei29, Oct 21, 2012.

  1. meimei29

    meimei29 Guest

    Hi :)

    I was wondering if it's possible to have an IF THEN statement leading t
    a formula. I attempted using Microsoft's help guide online, an
    unfortunately, to no avail.

    Basically, I was hoping to be able to check a field, and depending on i
    they were female or male, the equation would be different. The equation
    in the IF field would be

    ((140-I1)*B1*.85)/(72*D1)
    ((140-I1)*B1)/(72*D1)

    I feel like I'm close, but so very far.. is it because Word does no
    support formulas in If-Then statements? I have..

    IF {J1 = "Female"} {=((140-I1)*B1*.85)/(72*D1)
    {=((140-I1)*B1)/(72*D1)}

    As you may suspect, currently, it is just displaying this as text.. s
    if it's Female, it's showing as {=((140-I1)*B1*.85)/(72*D1)}. What i
    missing


    --
    meimei29
     
    meimei29, Oct 21, 2012
    #1
    1. Advertisements

  2. meimei29

    Stefan Blom Guest

    Is B1 a cell reference? In that case, the whole field must be inside a table
    cell or it won't work. If the data is outside of a table, you can insert it (for
    calculation purposes) via a REF field.

    Also, remember that field delimiters must be added by pressing Ctrl+F9 (you
    can't type them in).

    --
    Stefan Blom
    Microsoft Word MVP




    "meimei29" wrote in message news:...

    Hi :)

    I was wondering if it's possible to have an IF THEN statement leading to
    a formula. I attempted using Microsoft's help guide online, and
    unfortunately, to no avail.

    Basically, I was hoping to be able to check a field, and depending on if
    they were female or male, the equation would be different. The equations
    in the IF field would be

    ((140-I1)*B1*.85)/(72*D1)
    ((140-I1)*B1)/(72*D1)

    I feel like I'm close, but so very far.. is it because Word does not
    support formulas in If-Then statements? I have..

    IF {J1 = "Female"} {=((140-I1)*B1*.85)/(72*D1)}
    {=((140-I1)*B1)/(72*D1)}

    As you may suspect, currently, it is just displaying this as text.. so
    if it's Female, it's showing as {=((140-I1)*B1*.85)/(72*D1)}. What is
    missing?




    --
    meimei29
     
    Stefan Blom, Oct 21, 2012
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.