Below is part of a financial worksheet to calculate profit and loss.
Currently C19
shows £ 0.00
as there is no data in the next to calculate an answer.
I want cell C19
to return blank until such a point there is data in the next sheet to calculate an answer but NOT using custom number formats (as I am already using one that I would like to keep)
Custom number format already in use in cell C19
: + £ #,##0.00;- £ #,##0.00; 0.00
This is currently the formula in cell C19
: =SUMIF('SPREADS LOG'!A:A,"*OPEN*",'SPREADS LOG'!K:K)
Can anyone suggest the correct formula needed?
I see 4 solutions: