Formatting issue

I

Iriemon

I have the following formula in one of my cells:

=IF(C5<>0,C6 &" Supplied by Marketing - Calculated value is " &C4,C4&"
Calculated value")

The values in C4, C5, C6 are all in dollar format but the output doesn't
show in dollar format. See below:

7500 Supplied by Marketing - Calculated value is 8800 .

Any way to get the format like this:

$7,500.00 Supplied by Marketing - Calculated value is $8,800.00
 
E

Eduardo

Hi,

=IF(C5<>0,"$"&C6&" Supplied by Marketing - Calculated value is "&"$"&C4,C4&"
")
 

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

change cell color depending on two cell values 1
Conditional formatting multiple cells from one cell to another 3
Using the Icon Set for Conditional Formatting 1
Use TODAY() function as the criteria in a SUMIF formula 1
= cell above last entered data 9
IF argument limit - how convert formula to VBA? 2
Payment calculation 1
Same =rand() value in two adjacent cells in column 2

Top