Hello, I have a system stock report which has some empty cells (depending on the day's movements). The empty cells should stay empty.

I then work out whether we've bought or sold at a profit or loss (I have weekly nominal prices to do this).

It means I end up with 3 key columns, something like this:

1. If the stock movement in purchases cell is empty, don't do the calculation; if there's a quantity, calculate the variance against the nominal buying price.
2. If the stock movement in sales cell is empty, don't do the calculation; if there's a quantity, calculate the variance against the nominal selling price.
3. Add the 2 outcomes together.

I can either have a formula in column 3 like this: =+IF(F5="","",+C5*F5-H5*F5)+IF(K5="","",-H5*K5+M5*K5)
Or I can simply add the cells that contain the result from Calc 1 and the result from Calc 2.

Either way I end up with #VALUE! as my result. How can I calculate my 'profit/loss' on a product type on the above basis?

Many thanks
Danielle