IF FORMULA

K

katest

I am trying to add up a colomn that includes cells containing 'if' formulas
but the total misses out the value in the the cells containing the formula.
Can anyone help?
 
B

Bob Phillips

It shouldn't. Are those cells showing the value as numbers okay?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
K

katest

The value is showing. I have tried to convert the result of this cell to
'currency' but it will not convert so I changed back to number. It's as if
excel is seeing it as a blank cell as there is only the result of the formula
in it. Any ideas? Thanks, Kate.
 
R

Richard Buttrey

I am trying to add up a colomn that includes cells containing 'if' formulas
but the total misses out the value in the the cells containing the formula.
Can anyone help?
Click to expand...

Could you post an example of the 'IF' formula you're using and the
details of the contents of the cells that the formula is referencing?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
K

katest

Sorry, how do I do that?


Richard Buttrey said:
Could you post an example of the 'IF' formula you're using and the
details of the contents of the cells that the formula is referencing?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
Click to expand...
 
K

katest

Perhaps this is what you need? The formula is:

=IF(C4<7998,"£7992.00",IF(C4<9498,"£15984.00",IF(C4<100998,"£23976.00",
IF(C4<12498,"£31968.00",IF(C4<13998,"£39960.00",IF(C4<15498,"£47952.00",IF(C4>16998,"£55944.00")))))))

This formula is working and giving the right results but it not included in
the total of the column

Ta, Kate
 
Top