| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help me I've forgotten the formula and I can't figure it out
Can someone be kind to me and remind me how to format a number within
the formula. I've got this formula ="TOTAL COST - "&(SUMIF(PC,"1200",Db)) and I want the (SUMIF(PC,"1200",Db)) to return as a currency value, so the output would be TOTAL COST - $9000.00 I remember doing it before but I've since lost my bookmarks and I've been unsuccesful in finding it again. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Help me I've forgotten the formula and I can't figure it out
ONe way:
="TOTAL COST - " & TEXT(SUMIF(PC,"1200",Db),"$#,##0.00") In article .com, "Santa-D" wrote: Can someone be kind to me and remind me how to format a number within the formula. I've got this formula ="TOTAL COST - "&(SUMIF(PC,"1200",Db)) and I want the (SUMIF(PC,"1200",Db)) to return as a currency value, so the output would be TOTAL COST - $9000.00 I remember doing it before but I've since lost my bookmarks and I've been unsuccesful in finding it again. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula to give 5%rise in a figure if it occurs b/wn 2 dates | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| How do figure excel formula out? | Excel Discussion (Misc queries) | |||
Linear Mode
