Prev: Populating a range from tab b into tab a
Next: If yes then display information in cell
From: Iriemon on 24 Feb 2010 10:09
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


From: Eduardo on 24 Feb 2010 10:17
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
>
>
From: Iriemon on 24 Feb 2010 10:23
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
> >
> >
 | 
Pages: 1
Prev: Populating a range from tab b into tab a
Next: If yes then display information in cell