T
Terregles99
I have a spreadhseet that contains an "IF" statement as follows:
=IF(D5>0,"£150.00","0"). This statement works fine. I want to add up the
total at the bottom of the column containing the formula, but the =SUM
function doesn't appear to recognise the £150.00 as a value - I cannot get it
to "see" the amount.
I know this probably has a very simple solution but I've been working 12-14
hour days for 3 weeks without a break and cannot work out the solution
myself. Any help would be more appreciated than a bottle of gin tonight.
Thanks
=IF(D5>0,"£150.00","0"). This statement works fine. I want to add up the
total at the bottom of the column containing the formula, but the =SUM
function doesn't appear to recognise the £150.00 as a value - I cannot get it
to "see" the amount.
I know this probably has a very simple solution but I've been working 12-14
hour days for 3 weeks without a break and cannot work out the solution
myself. Any help would be more appreciated than a bottle of gin tonight.
Thanks