| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __________________________ |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 __________________________ |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
