This sounds like a fairly straightforward calculated field. In the table window, click on Data > Calculated Field, click on New, select Formula-based. Call the field "CORRECT COST", define the type as numeric and select the appropriate decimals and formatting.
In the Formula tab, something like:
should work. You can then hide the old COST field to keep the table tidy, and repeat for RESALE.
Does this solve the problem?