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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Mandi Arvanitakis

    Sorting on Surname then First Initials

    Mandi Arvanitakis, Dec 4, 2003, in forum: Word Tables
    Replies:
    1
    Views:
    96
    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:
    71
    Graham Mayor
    Jan 7, 2004
  3. Rudy1
    Replies:
    6
    Views:
    113
    Stefan Blom
    Mar 23, 2005
  4. mom2kidzz
    Replies:
    1
    Views:
    88
    Suzanne S. Barnhill
    Dec 15, 2004
  5. Sidney
    Replies:
    1
    Views:
    87
    Doug Robbins - Word MVP
    Dec 25, 2004
  6. Perplexed
    Replies:
    1
    Views:
    66
    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:
    139
  8. sombera
    Replies:
    3
    Views:
    93
    Tony Jollans
    Sep 26, 2006
Loading...