result 2 of "if" function should be don't calculate

[michele]

This must be a very easy one but I just can't seem to figure it out.

I only want the field to be calculated if it's empty, so if there is a result already it should not calculate again

If (field1=field2;result 1;don't change current field value)

Thankyou so much for helping me out

[SteveB]

Change the IF function to a Case Function:

Case(Field1=Field2,Result1)

[ September 02, 2001: Message edited by: Steveinvegas ]