Calculate negative values

Hi All,

I have a problem with a formula I am using to calculate reserve storage.

I have tried using an advanced formula but it is not producing the result I need. Rather, my formula is displaying negative values in some cases (see attached reference file highlighted cell E13).

If the formula is going to produce a negative value, I want it to display a blank cell instead.

I have attached a working file for reference.

Can someone point me in the right direction PLEASE?

Thanks

Hi,

In E2 and copied down:

=IF(A2="",IF(((B2*C2)-(D2/2))/(D2)<0,0,((B2*C2)-(D2/2))/(D2)),0)

or simplified

=IF(A12="",IF(B12*C12*2<D12,0,(B12*C12-D12/2)/D12)),0)

Another alternative

E2: =MAX(0,((B2*C2)-(D2/2))/D2)*(A2="")
copied down

If you want 0 to appear as blank use a Custom Format of: [=0]"";0.00