ExcelBanter - Help me I've forgotten the formula and I can't figure it out

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help me I've forgotten the formula and I can't figure it out (https://www.excelbanter.com/excel-worksheet-functions/71201-help-me-ive-forgotten-formula-i-cant-figure-out.html)

Santa-D

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.

JE McGimpsey

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.

All times are GMT +1. The time now is 08:18 AM.