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

S

Santa-D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help me I've forgotten the formula and I can't figure it out 3
IF formula can't figure out, please help 4
How do I create a formula in excel to multiply two items from two 2
Why can't I just use the = sign in a function, and not use >=? 8
Mix/Max/Avg Help based on dynamic ranges 16
formula I can't figure it out?! ARGH 4
Games I've been playing lately and the state of things Chez Flops 3
Help with MAX / MIN formula (I think) 13

Top