Hi,
I have a made a number of spreadsheets which have a sub-totals formula for corresponding cells. The formula for example "=IF(C3>0,C3-B3,-B3)".
If I insert the formula in D3 and drag it down to D50 (or any number) all the D cells show £0.00. Can I make an addition to the formula that will NOT show a value until cells C and B are given a value?
I hope I've explained it properly
Thanks in advance
I have a made a number of spreadsheets which have a sub-totals formula for corresponding cells. The formula for example "=IF(C3>0,C3-B3,-B3)".
If I insert the formula in D3 and drag it down to D50 (or any number) all the D cells show £0.00. Can I make an addition to the formula that will NOT show a value until cells C and B are given a value?
I hope I've explained it properly
Thanks in advance