if formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lost in cincy - 22 Nov 2004 18:05 GMT

i'm trying to figure out a formula for the following:
If bal <3000.00 "125.00" "if bal >10000.00 "250.00"
but how to I get if bal >3000.00 but <10000.00 "150.00"

Reply to this Message

Graham Mayor - 22 Nov 2004 18:23 GMT

If bal is a bookmark then
{ IF { REF bal } < 3000 "125.00" "{ IF { REF bal } < 10000 "150.00"
"250.00"}" }
If bal is a mergefield change REF to Mergefield

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> i'm trying to figure out a formula for the following:
> If bal <3000.00 "125.00" "if bal >10000.00 "250.00"
> but how to I get if bal >3000.00 but <10000.00 "150.00"

Reply to this Message

macropod - 23 Nov 2004 06:37 GMT

Hi Graham,

Equally, you could use:
{=IF(bal<3000,125,IF(bal<10000,150,250)) \# 0.00}

Cheers

> If bal is a bookmark then
> { IF { REF bal } < 3000 "125.00" "{ IF { REF bal } < 10000 "150.00"
[quoted text clipped - 4 lines]
> > If bal <3000.00 "125.00" "if bal >10000.00 "250.00"
> > but how to I get if bal >3000.00 but <10000.00 "150.00"

Reply to this Message

Graham Mayor - 23 Nov 2004 08:33 GMT

Works for me ;)

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> Hi Graham,
>
[quoted text clipped - 24 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.799 / Virus Database: 543 - Release Date: 19/11/2004

Reply to this Message