AnsweredAssumed Answered

Calculation choice from one of two fields

Question asked by on Feb 6, 2018
Latest reply on Feb 6, 2018 by philmodjunk

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.