I have a spreadhseet that contains an "IF" statement as follows:

=IF(D50,"£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

By using quotes you are forcing the results to be text. You want them to be
numbers.

=IF(D50,150.00,0)

For the cell that contains 150, just format the cell as currency and select
the appropriate Symbol from the dropdown.

HTH,
Paul


--

"Terregles99" wrote in message
...
I have a spreadhseet that contains an "IF" statement as follows:

=IF(D50,"£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

Change your formula to
=IF(D50,150,0)

You will need to format your cells as £. What you have is text and not
numbers. You can not perform calculations on text.
--
HTH...

Jim Thomlinson


"Terregles99" wrote:

I have a spreadhseet that contains an "IF" statement as follows:

=IF(D50,"£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(D50,"£150.00","0")

Remove the quotes from around the numbers:

=IF(D50,150,0)

Or:

=(D50)*150

To get the cell to display as £150.00, goto FormatCellsCurrency. Select
the desired symbol and number of decimal places.

--
Biff
Microsoft Excel MVP


"Terregles99" wrote in message
...
I have a spreadhseet that contains an "IF" statement as follows:

=IF(D50,"£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