Reply
 
Thread Tools Display Modes
  #1   Report Post  
meimei29 meimei29 is offline
Junior Member
 
Posts: 1
Default IF THEN Formula Statement

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?
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
which statement right , question is Choose the correct statement? how many template?when we click new doc Microsoft Word Help 1 October 16th 06 11:15 AM
which statement right , question isChoose the correct statement? how many template?when we click new doc Microsoft Word Help 1 October 15th 06 11:20 PM
How can I? If statement ? Buttercup Mailmerge 2 November 23rd 05 06:49 PM
how to align caption of formula right whereas formula itself left Martin van Leeuwen Microsoft Word Help 1 October 22nd 05 06:39 AM
If Then statement Brw Microsoft Word Help 2 June 9th 05 04:12 AM


All times are GMT +1. The time now is 08:41 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"