IF FORMULA
 

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?

IF FORMULA
 

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)

"katest" wrote in message
...
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?

IF FORMULA
 

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.

"Bob Phillips" wrote:

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)

"katest" wrote in message
...
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?

IF FORMULA
 

On Thu, 29 Jun 2006 03:56:02 -0700, katest
wrote:

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
__________________________

IF FORMULA
 

Sorry, how do I do that?


"Richard Buttrey" wrote:

On Thu, 29 Jun 2006 03:56:02 -0700, katest
wrote:

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
__________________________

IF FORMULA
 

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(C416998,"£55944.00") ))))))

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

Ta, Kate


"katest" wrote:

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?

IF FORMULA
 

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

"katest" wrote:

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(C416998,"£55944.00") ))))))

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

Ta, Kate


"katest" wrote:

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?

IF FORMULA
 

Brilliant!! Thanks very much.

"Toppers" wrote:

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

"katest" wrote:

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(C416998,"£55944.00") ))))))

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

Ta, Kate


"katest" wrote:

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?