"Max" wrote:

Try instead in J2: =IF(H2="L",-G2,IF(H2="W",G2*E2/F2,""))

Sorry, the formula above should be in I2, not J2

And to avoid potential downstream calculation problems in col J,
think it's better to make the formula return zero if FALSE
(instead of it returning blanks: ""), so ..

Put in I2: =IF(H2="L",-G2,IF(H2="W",G2*E2/F2,0))
Copy I2 down
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895

Fantatsic, your genius, Thank Max it works, really grateful.

One further question. Is there away to 'hide' the formula in a saved
worksheet?
--