| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
