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

S

Santa-D

This is a simple straight forward task and I can't remember how to do
it.

When inserting a formula you can customise the output of a number,
however I can't remember to do it, I keep trying to use the CCUR
function found in most programming languages but I forget to remember
that this isn't in excel.

This is what I've got.

="TOTAL COST - "&(SUMIF(PC,"1200",Db))

Now the (SUMIF(PC,"1200",Db)) returns a number which I want to convert
to a currency whilst it's in the string, can someone be kind to me and
remind me how to do it. I've searched Microsoft's helpfiles and done
Google Groups search but I appear to be missing something.
 
S

Santa-D

I just found a way around it by using the Dollar function.

The formula now looks like - ="TOTAL COST -
"&DOLLAR((SUMIF(PC,"1200",Db)),2)
 
P

Peo Sjoblom

You can use the TEXT function,

="TOTAL COST -
"&TEXT(SUMIF(PC,"1200",Db),"$#,##0.00")

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon
 
S

Santa-D

Thanks Peo,

This is what I was trying to find as this is what I was trying to
remember.
 
Top