IF formula in Word Table

[LindaM]

I'm trying to insert the equivalent of Excel: =IF(B5<=9,"10
days",IF(B5<=19,"15 days","20 days")) into a word table, where b5 is the
table reference containing a sum field. I've had a variety of responses,
none of which is correct. Any suggestions?

 

[macropod]

Hi Linda,

When you're using text in a formula in Word, you need a completely different
syntax from what you'd use in Excel.

There are two solutions to your problem, one that allows you to use an Excel
syntax, by not having "days" in the formula itself, and the other that does:

First solution. Construct your formula as-
{=IF(B5<=19,15,20)} days

Second solution. Construct your formula as-
{IF{=B5}<= 19 "15 days" "20 days"}

In both formulae, the '{}] are the field braces created via CTRL-F9.

Cheers

 

[LindaM]

Thanks for this, but I'm still having a problem. I need to nest the IF
formulae so that if b5 = less than 9 enter 10 days, if 10 to 19 enter 15
days, if 20+ enter 20 days. It's this nesting that's really messing me up.

cheers
Linda

Hi Linda,

When you're using text in a formula in Word, you need a completely different
syntax from what you'd use in Excel.

There are two solutions to your problem, one that allows you to use an Excel
syntax, by not having "days" in the formula itself, and the other that does:

First solution. Construct your formula as-
{=IF(B5<=19,15,20)} days

Second solution. Construct your formula as-
{IF{=B5}<= 19 "15 days" "20 days"}

In both formulae, the '{}] are the field braces created via CTRL-F9.

Cheers

I'm trying to insert the equivalent of Excel: =IF(B5<=9,"10
days",IF(B5<=19,"15 days","20 days")) into a word table, where b5 is the
table reference containing a sum field. I've had a variety of responses,
none of which is correct. Any suggestions?

 

[macropod]

Hi Linda,

In that case, you could use:
{=IF(B5<10,10,IF(B5<20,15,20))} days
or
{IF{=B5}< 10 "10 days" {IF{=B5}< 20 "15 days" "20 days"}}

Cheers

Thanks for this, but I'm still having a problem. I need to nest the IF
formulae so that if b5 = less than 9 enter 10 days, if 10 to 19 enter 15
days, if 20+ enter 20 days. It's this nesting that's really messing me up.

cheers
Linda

Hi Linda,

When you're using text in a formula in Word, you need a completely different
syntax from what you'd use in Excel.

There are two solutions to your problem, one that allows you to use an Excel
syntax, by not having "days" in the formula itself, and the other that does:

First solution. Construct your formula as-
{=IF(B5<=19,15,20)} days

Second solution. Construct your formula as-
{IF{=B5}<= 19 "15 days" "20 days"}

In both formulae, the '{}] are the field braces created via CTRL-F9.

Cheers

I'm trying to insert the equivalent of Excel: =IF(B5<=9,"10
days",IF(B5<=19,"15 days","20 days")) into a word table, where b5 is the
table reference containing a sum field. I've had a variety of responses,
none of which is correct. Any suggestions?

 

[LindaM]

Hey it works! Thanks for your time and expertise.

Hi Linda,

In that case, you could use:
{=IF(B5<10,10,IF(B5<20,15,20))} days
or
{IF{=B5}< 10 "10 days" {IF{=B5}< 20 "15 days" "20 days"}}

Cheers

Thanks for this, but I'm still having a problem. I need to nest the IF
formulae so that if b5 = less than 9 enter 10 days, if 10 to 19 enter 15
days, if 20+ enter 20 days. It's this nesting that's really messing me up.

cheers
Linda

Hi Linda,

When you're using text in a formula in Word, you need a completely different
syntax from what you'd use in Excel.

There are two solutions to your problem, one that allows you to use an Excel
syntax, by not having "days" in the formula itself, and the other that does:

First solution. Construct your formula as-
{=IF(B5<=19,15,20)} days

Second solution. Construct your formula as-
{IF{=B5}<= 19 "15 days" "20 days"}

In both formulae, the '{}] are the field braces created via CTRL-F9.

Cheers

I'm trying to insert the equivalent of Excel: =IF(B5<=9,"10
days",IF(B5<=19,"15 days","20 days")) into a word table, where b5 is the
table reference containing a sum field. I've had a variety of responses,
none of which is correct. Any suggestions?