This will not work as you are trying to set Field3 to a value that includes
field3, this will give a circular reference.

If you ahd another field/cell, you could use

=IF(Field2<Field1, Field1-Field2+Field3,IF(Field2Field1,
Field3-Field2+Field3)

Are you sure about that last condition? Field 3 - Field 2 + Field 3 is the
same as -Field2.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"NSF" wrote in message
...


I have been using some old software to provide what i need but want to
move
to Microsoft.

The formular that has been used in the old software (Q&A Version 3) is:

IF Field 2< Field 1 then Field 3 = Field 1 - Field 2 + Field 3 ELSEIF
Field
2 Field 1 then Field 3 = Field 3 - Field 2 + Field 3

Can anyone work out a conversion that will work?

Thanks


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.668 / Virus Database: 430 - Release Date: 24/04/2004