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

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.
Similar Threads
  1. Mandi Arvanitakis

    Sorting on Surname then First Initials

    Mandi Arvanitakis, Dec 4, 2003, in forum: Word Tables
    Replies:
    1
    Views:
    116
    Cindy M -WordMVP-
    Dec 19, 2003
  2. kimatdsc

    using if/then in Word 2000 table

    kimatdsc, Jan 6, 2004, in forum: Word Tables
    Replies:
    1
    Views:
    92
    Graham Mayor
    Jan 7, 2004
  3. Rudy1
    Replies:
    6
    Views:
    132
    Stefan Blom
    Mar 23, 2005
  4. mom2kidzz
    Replies:
    1
    Views:
    106
    Suzanne S. Barnhill
    Dec 15, 2004
  5. Sidney
    Replies:
    1
    Views:
    107
    Doug Robbins - Word MVP
    Dec 25, 2004
  6. Perplexed
    Replies:
    1
    Views:
    87
    Greg Maxey
    Jun 8, 2005
  7. Graham Smith 450-458-0101

    Freeze row height then put button to view entire cell

    Graham Smith 450-458-0101, Feb 24, 2006, in forum: Word Tables
    Replies:
    6
    Views:
    178
  8. sombera
    Replies:
    3
    Views:
    111
    Tony Jollans
    Sep 26, 2006
Loading...