Hello --

I'm looking to have a formula that if there is a specific Unit Cost that it calculates the Total Cost as Unit Cost * Quantity

BUT - If the Unit Cost is empty I want the formula to calculate from an Estimated Cost field * Quantity.

I've tried the IF and EMPTY commands, but I'm obviously doing something wrong...

Any help would be greatly appreciated.

Ryan

You could write it several different ways. In all cases, this should be an auto-enter calculation with the "do not replace..." check box cleared.

Here's what's probably the most straight forward way to write it, assuming that all fields are in the same record:

If ( IsEmpty ( UnitCost ) ; Estimated Cost field * Quantity ; Unit Cost * Quantity )