Formula in a Customized Field

[Slim]

Thanks in advance for the help.

I am using 3 number fields to calculate earned value.
I'm doing this because we do not use resource loaded
schedules.

Since a milestone will have a zero (0) value, I can have
a situation where I am dividing by zero.

I want to use the If, Then, Else function, but this
function is not available in the Formula dialog box.

Any Ideas?

Here is what I have now that works as long as I do not
divide by zero:

Variables
Number6 = % Comp = EV / Budget
Number7 = Budget
Number8 = Earned Value

Formula that works: [Number6] = [Number8]/[Number7]

The following formula does not work:

If([Number7] = 0, then [Number6] = 0, else [Number8]/
[Number7])

Thanks again,

Slim

 

[Gérard Ducouret]

Hello Slim,
Then "Then" and the "Else" are implicit in Project formulas (like in Excel)
Try this one :

IIf([Numéro7]=0;0;[Numéro8]/[Numéro7])

Gérard Ducouret [Project MVP]

 

[Guest]

Gerard,

Thanks much - IT WORKED -

Slim

-----Original Message-----
Hello Slim,
Then "Then" and the "Else" are implicit in Project formulas (like in Excel)
Try this one :

IIf([Numéro7]=0;0;[Numéro8]/[Numéro7])

Gérard Ducouret [Project MVP]

"Slim" <[email protected]> a écrit dans le message de

Thanks in advance for the help.

I am using 3 number fields to calculate earned value.
I'm doing this because we do not use resource loaded
schedules.

Since a milestone will have a zero (0) value, I can have
a situation where I am dividing by zero.

I want to use the If, Then, Else function, but this
function is not available in the Formula dialog box.

Any Ideas?

Here is what I have now that works as long as I do not
divide by zero:

Variables
Number6 = % Comp = EV / Budget
Number7 = Budget
Number8 = Earned Value

Formula that works: [Number6] = [Number8]/[Number7]

The following formula does not work:

If([Number7] = 0, then [Number6] = 0, else [Number8]/
[Number7])

Thanks again,

Slim

.