IF FORMULA

[Guest]

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?

 

[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)

 

[Guest]

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.

 

[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?

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
__________________________

 

[Guest]

Sorry, how do I do that?

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
__________________________

 

[Guest]

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

 

[Guest]

Remove the quotes from the values i.e 7992.00 not "£7992.00"
HTH

 

[Guest]

Brilliant!! Thanks very much.

Remove the quotes from the values i.e 7992.00 not "£7992.00"
HTH