Hi

Please see the following:

[ATTACH]please see this 12711[/ATTACH]

I have column A11 at £0.00 as the amount of column A8 equals the total amount of column A2. =IF(S4 = "", "",MIN(S4*Q4,F4))
I was looking to have a similar formula for column A10 as to when column A8 equals A2 I want A10 to read as 0.
The current formula I have for A10 is =IF(N4 = "", "", NETWORKDAYS(L4, N4))
Can anyone help please?

Attached Images

SpreadsheetEG.png (4.9 KB, 17 views)