automated field based on value of multiple fields

[Tain71]

I have a risk assessment form. In one area of the form, there are four fields: Performance, Schedule, Cost & Consequence/Impact.

I want the field "Consequence/Impact" to equal the highest value of the other three fields. Keep in mind the other three field values are anything between 1-5 (all different).

For example; if Performance=1, Schedule=5 & Cost =3, then Consequence/Impact will equal 5 because that's the highest of the three fields.

I have tried several expressions (i.e., =MAX(performance,schedule, cost) and nothing works. Can anyone help? Thanks!

 

[MattS]

It's not very neat, but I think the following would work:

=IIf([Performance]>[Schedule],IIf([Performance]>[Cost],[Performance],[Cost]),IIf([Schedule]>[Cost],[Schedule],[Cost]))

HTH,

Matt.