ExcelBanter - Formatting issue

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

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

- - Formatting issue (https://www.excelbanter.com/excel-worksheet-functions/257270-formatting-issue.html)

Iriemon

Formatting issue

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

Eduardo

Formatting issue

Hi,

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

"Iriemon" wrote:

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

Iriemon

Formatting issue

Thanks Eduardo! works fine!

"Eduardo" wrote:

Hi,

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

"Iriemon" wrote:

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

All times are GMT +1. The time now is 12:17 AM.