if formula

[lost in cincy]

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"

 

[Graham Mayor]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[macropod]

Hi Graham,

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

Cheers

 

[Graham Mayor]

Works for me

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>