[jlawson]

I have the "If Then" statement working in it's simplest form but I
think i have the formatting on the calculation wrong. This is what I
have so far:

{=if (A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1}

OR

=IF (3000900,(3000-900)-((3000-900)*.70)+900,3000)

Can anyone tell me what it is I am doing wrong?

[macropod]

Hi jlawson,

Apart from a missing ')' and what might be an erroneous reference to B2,
your formula looks and works fine. You should have:
{=if(A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1)}
The result of the calculation using the values you posted is 1530.

What result were you expecting?

Cheers

--
macropod
[MVP - Microsoft Word]


"jlawson" wrote in message
ps.com...
I have the "If Then" statement working in it's simplest form but I
think i have the formatting on the calculation wrong. This is what I
have so far:

{=if (A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1}

OR

=IF (3000900,(3000-900)-((3000-900)*.70)+900,3000)

Can anyone tell me what it is I am doing wrong?

[jlawson]

Thank you, Macropod

The problem I am getting is that the field is copying Hospital cost
field. This is what I have so far:

{=if(fHospCostfDedLeft,(fHospCost - fDedLeft)-((fHospCost -
fDedLeft)*fPer)+fDedLeft,fHospCost)}

The formfield bookmarks a

fHospCost = Estimated hospital charges to the patient
fDedLeft = How much of a deductible the patient has
fPer = How much of a percentage the patient's insurance company will
pay after the deductible is met.

If I put in $3000 in the estimated hospital charges field, $900 in the
deductible field and .70 in the percent field then the formula just
copies the $3000. It does not do any of the calculations.



macropod wrote:
Hi jlawson,

Apart from a missing ')' and what might be an erroneous reference to B2,
your formula looks and works fine. You should have:
{=if(A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1)}
The result of the calculation using the values you posted is 1530.

What result were you expecting?

Cheers

--
macropod
[MVP - Microsoft Word]


"jlawson" wrote in message
ps.com...
I have the "If Then" statement working in it's simplest form but I
think i have the formatting on the calculation wrong. This is what I
have so far:

{=if (A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1}

OR

=IF (3000900,(3000-900)-((3000-900)*.70)+900,3000)

Can anyone tell me what it is I am doing wrong?

[macropod]

Hi jlawson,

Unless you're using a form, with fields set to 'calculate on exit', field
calculations in Word aren't automatic - you need to select the field (or the
whole document for all fields) and press F9.

--
macropod
[MVP - Microsoft Word]


"jlawson" wrote in message
oups.com...
Thank you, Macropod

The problem I am getting is that the field is copying Hospital cost
field. This is what I have so far:

{=if(fHospCostfDedLeft,(fHospCost - fDedLeft)-((fHospCost -
fDedLeft)*fPer)+fDedLeft,fHospCost)}

The formfield bookmarks a

fHospCost = Estimated hospital charges to the patient
fDedLeft = How much of a deductible the patient has
fPer = How much of a percentage the patient's insurance company will
pay after the deductible is met.

If I put in $3000 in the estimated hospital charges field, $900 in the
deductible field and .70 in the percent field then the formula just
copies the $3000. It does not do any of the calculations.



macropod wrote:
Hi jlawson,

Apart from a missing ')' and what might be an erroneous reference to B2,
your formula looks and works fine. You should have:
{=if(A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1)}
The result of the calculation using the values you posted is 1530.

What result were you expecting?

Cheers

--
macropod
[MVP - Microsoft Word]


"jlawson" wrote in message
ps.com...
I have the "If Then" statement working in it's simplest form but I
think i have the formatting on the calculation wrong. This is what I
have so far:

{=if (A1B1,(A1-B1)-((A1-B2)*C1)+B1,A1}

OR

=IF (3000900,(3000-900)-((3000-900)*.70)+900,3000)

Can anyone tell me what it is I am doing wrong?