how do i write a complex expression

I need to mulitiply an amount from a REF Field by 3. If the product is less
than and equal to $100. then $100. If the product is greater than and equal
to $500., then $500. If the products falls between $100. and $500 then the
calculated amount should be entered

Tony
Thu Nov 17 13:16:50 CST 2005

{ = min(max({={ref whatever}*3}, 100), 500) }

--
Enjoy,
Tony


"bobotie" <bobotie@discussions.microsoft.com> wrote in message
news:3E9AA364-AA09-4307-B2D2-2CB5AF9F558A@microsoft.com...
> I need to mulitiply an amount from a REF Field by 3. If the product is
less
> than and equal to $100. then $100. If the product is greater than and
equal
> to $500., then $500. If the products falls between $100. and $500 then
the
> calculated amount should be entered

Tony
Thu Nov 17 13:32:38 CST 2005

Sorry, to show dollars, do this ..

{ = min(max({={ref whatever}*3}, 100), 500) \# "$0"}

This may not give what you want if you can have negative values in the
referenced field. post back if that's the case.

--
Enjoy,
Tony


"Tony Jollans" <My Forename at My Surname dot com> wrote in message
news:OHTlNu66FHA.3592@TK2MSFTNGP12.phx.gbl...
> { = min(max({={ref whatever}*3}, 100), 500) }
>
> --
> Enjoy,
> Tony
>
>
> "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> news:3E9AA364-AA09-4307-B2D2-2CB5AF9F558A@microsoft.com...
> > I need to mulitiply an amount from a REF Field by 3. If the product is
> less
> > than and equal to $100. then $100. If the product is greater than and
> equal
> > to $500., then $500. If the products falls between $100. and $500 then
> the
> > calculated amount should be entered
>
>

bobotie
Fri Nov 18 11:37:18 CST 2005

Thanks, this helped a lot. How do i find the reference field # or name for
this expression? I need to calculate the sum of 4 field results, one of
which includes this field expression.
Thanks again
bobotie

"Tony Jollans" wrote:

> Sorry, to show dollars, do this ..
>
> { = min(max({={ref whatever}*3}, 100), 500) \# "$0"}
>
> This may not give what you want if you can have negative values in the
> referenced field. post back if that's the case.
>
> --
> Enjoy,
> Tony
>
>
> "Tony Jollans" <My Forename at My Surname dot com> wrote in message
> news:OHTlNu66FHA.3592@TK2MSFTNGP12.phx.gbl...
> > { = min(max({={ref whatever}*3}, 100), 500) }
> >
> > --
> > Enjoy,
> > Tony
> >
> >
> > "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> > news:3E9AA364-AA09-4307-B2D2-2CB5AF9F558A@microsoft.com...
> > > I need to mulitiply an amount from a REF Field by 3. If the product is
> > less
> > > than and equal to $100. then $100. If the product is greater than and
> > equal
> > > to $500., then $500. If the products falls between $100. and $500 then
> > the
> > > calculated amount should be entered
> >
> >
>
>
>

Tony
Fri Nov 18 13:54:54 CST 2005

Hi bobotie,

It doesn't have a name at the moment. If you want to give it a name, change
it to ..

{ set abcd { = min(max({={ref whatever}*3}, 100), 500) }}

This won't display anything, just set abcd to the value. If you also want it
to display either do ...

{ quote { set abcd { = min(max({={ref whatever}*3}, 100), 500) } { abcd \#
"$0"}}

... or, more simply perhaps, ...

{ set abcd { = min(max({={ref whatever}*3}, 100), 500) }} { abcd \# "$0" }

--
Enjoy,
Tony


"bobotie" <bobotie@discussions.microsoft.com> wrote in message
news:7AD134E0-D2D9-4DDA-9FBF-B549E4AB2FFC@microsoft.com...
> Thanks, this helped a lot. How do i find the reference field # or name
for
> this expression? I need to calculate the sum of 4 field results, one of
> which includes this field expression.
> Thanks again
> bobotie
>
> "Tony Jollans" wrote:
>
> > Sorry, to show dollars, do this ..
> >
> > { = min(max({={ref whatever}*3}, 100), 500) \# "$0"}
> >
> > This may not give what you want if you can have negative values in the
> > referenced field. post back if that's the case.
> >
> > --
> > Enjoy,
> > Tony
> >
> >
> > "Tony Jollans" <My Forename at My Surname dot com> wrote in message
> > news:OHTlNu66FHA.3592@TK2MSFTNGP12.phx.gbl...
> > > { = min(max({={ref whatever}*3}, 100), 500) }
> > >
> > > --
> > > Enjoy,
> > > Tony
> > >
> > >
> > > "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> > > news:3E9AA364-AA09-4307-B2D2-2CB5AF9F558A@microsoft.com...
> > > > I need to mulitiply an amount from a REF Field by 3. If the product
is
> > > less
> > > > than and equal to $100. then $100. If the product is greater than
and
> > > equal
> > > > to $500., then $500. If the products falls between $100. and $500
then
> > > the
> > > > calculated amount should be entered
> > >
> > >
> >
> >
> >

bobotie
Fri Nov 18 14:42:02 CST 2005

Tony
Does set abcd mean name expression abcd or anything i choose? If so, in my
total field i would write for example =sum(Text1, Text2, Text3, abcd)?
I'm new to this, my apologies for not getting it.
Am leaving for the day and will check back monday
Thanks, enjoy
bobotie

"Tony Jollans" wrote:

> Hi bobotie,
>
> It doesn't have a name at the moment. If you want to give it a name, change
> it to ..
>
> { set abcd { = min(max({={ref whatever}*3}, 100), 500) }}
>
> This won't display anything, just set abcd to the value. If you also want it
> to display either do ...
>
> { quote { set abcd { = min(max({={ref whatever}*3}, 100), 500) } { abcd \#
> "$0"}}
>
> ... or, more simply perhaps, ...
>
> { set abcd { = min(max({={ref whatever}*3}, 100), 500) }} { abcd \# "$0" }
>
> --
> Enjoy,
> Tony
>
>
> "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> news:7AD134E0-D2D9-4DDA-9FBF-B549E4AB2FFC@microsoft.com...
> > Thanks, this helped a lot. How do i find the reference field # or name
> for
> > this expression? I need to calculate the sum of 4 field results, one of
> > which includes this field expression.
> > Thanks again
> > bobotie
> >
> > "Tony Jollans" wrote:
> >
> > > Sorry, to show dollars, do this ..
> > >
> > > { = min(max({={ref whatever}*3}, 100), 500) \# "$0"}
> > >
> > > This may not give what you want if you can have negative values in the
> > > referenced field. post back if that's the case.
> > >
> > > --
> > > Enjoy,
> > > Tony
> > >
> > >
> > > "Tony Jollans" <My Forename at My Surname dot com> wrote in message
> > > news:OHTlNu66FHA.3592@TK2MSFTNGP12.phx.gbl...
> > > > { = min(max({={ref whatever}*3}, 100), 500) }
> > > >
> > > > --
> > > > Enjoy,
> > > > Tony
> > > >
> > > >
> > > > "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> > > > news:3E9AA364-AA09-4307-B2D2-2CB5AF9F558A@microsoft.com...
> > > > > I need to mulitiply an amount from a REF Field by 3. If the product
> is
> > > > less
> > > > > than and equal to $100. then $100. If the product is greater than
> and
> > > > equal
> > > > > to $500., then $500. If the products falls between $100. and $500
> then
> > > > the
> > > > > calculated amount should be entered
> > > >
> > > >
> > >
> > >
> > >
>
>
>

Tony
Fri Nov 18 15:09:44 CST 2005

Hi bobotie,

abcd can be any name you choose - I just used abcd as an example.

Have a good weekend!

--
Enjoy,
Tony


"bobotie" <bobotie@discussions.microsoft.com> wrote in message
news:391FEFB4-F13F-45BA-9327-C50AB05AF198@microsoft.com...
> Tony
> Does set abcd mean name expression abcd or anything i choose? If so, in
my
> total field i would write for example =sum(Text1, Text2, Text3, abcd)?
> I'm new to this, my apologies for not getting it.
> Am leaving for the day and will check back monday
> Thanks, enjoy
> bobotie
>
> "Tony Jollans" wrote:
>
> > Hi bobotie,
> >
> > It doesn't have a name at the moment. If you want to give it a name,
change
> > it to ..
> >
> > { set abcd { = min(max({={ref whatever}*3}, 100), 500) }}
> >
> > This won't display anything, just set abcd to the value. If you also
want it
> > to display either do ...
> >
> > { quote { set abcd { = min(max({={ref whatever}*3}, 100), 500) } { abcd
\#
> > "$0"}}
> >
> > ... or, more simply perhaps, ...
> >
> > { set abcd { = min(max({={ref whatever}*3}, 100), 500) }} { abcd \#
"$0" }
> >
> > --
> > Enjoy,
> > Tony
> >
> >
> > "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> > news:7AD134E0-D2D9-4DDA-9FBF-B549E4AB2FFC@microsoft.com...
> > > Thanks, this helped a lot. How do i find the reference field # or
name
> > for
> > > this expression? I need to calculate the sum of 4 field results, one
of
> > > which includes this field expression.
> > > Thanks again
> > > bobotie
> > >
> > > "Tony Jollans" wrote:
> > >
> > > > Sorry, to show dollars, do this ..
> > > >
> > > > { = min(max({={ref whatever}*3}, 100), 500) \# "$0"}
> > > >
> > > > This may not give what you want if you can have negative values in
the
> > > > referenced field. post back if that's the case.
> > > >
> > > > --
> > > > Enjoy,
> > > > Tony
> > > >
> > > >
> > > > "Tony Jollans" <My Forename at My Surname dot com> wrote in message
> > > > news:OHTlNu66FHA.3592@TK2MSFTNGP12.phx.gbl...
> > > > > { = min(max({={ref whatever}*3}, 100), 500) }
> > > > >
> > > > > --
> > > > > Enjoy,
> > > > > Tony
> > > > >
> > > > >
> > > > > "bobotie" <bobotie@discussions.microsoft.com> wrote in message
> > > > > news:3E9AA364-AA09-4307-B2D2-2CB5AF9F558A@microsoft.com...
> > > > > > I need to mulitiply an amount from a REF Field by 3. If the
product
> > is
> > > > > less
> > > > > > than and equal to $100. then $100. If the product is greater
than
> > and
> > > > > equal
> > > > > > to $500., then $500. If the products falls between $100. and
$500
> > then
> > > > > the
> > > > > > calculated amount should be entered
> > > > >
> > > > >
> > > >
> > > >
> > > >
> >
> >
> >