Hi,

I'm trying to write a formula to calculate a percentage...
My data is as follows:

Standard Cost = 10
Selling Price = 14
SP1 = 14
SP2 = 13
SP3 = 12

I need the formula to express...
If SP3 has a value, calculate % diff between SP3 and Standard cost. If SP3 =
0, calculate using SP2, if SP2 = 0, calculate using SP1, if SP1 = 0,
calculate using default selling price.

Help!