IF THEN Formula Statement

M

meimei29

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
 
S

Stefan Blom

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
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?
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Top