sample custom field formula

[wejiv]

I am trying to use MSProject 2003. I want to compare a number entered in to
a custom field against a range (0-255). What is a short and sweet way to do
this?

 

[JackD]

What do you mean compare?
Do you want to find if it is within the range? Outside the range? Where is
the range defined?
Usually I'd use the IIF function

IIF([number1]>255 OR [number1] < 0, "outside range", "within range")

You can look here for more information on Custom Field Formulas:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html

 

[wejiv]

I simply want to put a formula in the edit formula box that answers to
"Fieldname = " such that Fieldname (a value that the user provides) is
between 0 and 255.

What do you mean compare?
Do you want to find if it is within the range? Outside the range? Where is
the range defined?
Usually I'd use the IIF function

IIF([number1]>255 OR [number1] < 0, "outside range", "within range")

You can look here for more information on Custom Field Formulas:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html
--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

I am trying to use MSProject 2003. I want to compare a number entered in to
a custom field against a range (0-255). What is a short and sweet way to do
this?

 

[JackD]

I still do not know what that means. Do you want to validate the input? That
is do you want to make sure that the user enters a value between 0 and 255?
If so you need to do some more complicated programming.

--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

I simply want to put a formula in the edit formula box that answers to
"Fieldname = " such that Fieldname (a value that the user provides) is
between 0 and 255.

What do you mean compare?
Do you want to find if it is within the range? Outside the range? Where is
the range defined?
Usually I'd use the IIF function

IIF([number1]>255 OR [number1] < 0, "outside range", "within range")

You can look here for more information on Custom Field Formulas:
http://zo-d.com/blog/archives/programming/working-with-custom-field-formulas.html
--
-Jack ... For Microsoft Project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

I am trying to use MSProject 2003. I want to compare a number entered

in
to

a custom field against a range (0-255). What is a short and sweet way

to
do

this?