Formatting dollar values in text

[LabrGuy Bob R]

Hello, I have Excel 2003 and Windows XP Pro.

I use this formula and it works exactly like I want it to except::

=IF(AC8<AC7,"YES Credit for " & "$" & AC8,"NO Max Credit for " & "$" & AC7)

AC8 and AC7 are both currency values and I get formatting of it like this
$133
$133.1
$133.10

I would always like to return a full currency value like the $133.10 but
can't figure it out. The two cells are both formatted in currency and
display two decimal places

Anyone have any ideas that it will format each time??
Thanks
Bob R

 

[Don Guillett]

You may prefer to have a look in the help index for DOLLAR

 

[Niek Otten]

Hi Bob,

=IF(AC8<AC7,"YES Credit for "&TEXT(AC8,"$#,##0.00"),"NO Max Credit for "&TEXT(AC7,"$#,##0.00"))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hello, I have Excel 2003 and Windows XP Pro.
|
| I use this formula and it works exactly like I want it to except::
|
| =IF(AC8<AC7,"YES Credit for " & "$" & AC8,"NO Max Credit for " & "$" & AC7)
|
| AC8 and AC7 are both currency values and I get formatting of it like this
| $133
| $133.1
| $133.10
|
| I would always like to return a full currency value like the $133.10 but
| can't figure it out. The two cells are both formatted in currency and
| display two decimal places
|
| Anyone have any ideas that it will format each time??
| Thanks
| Bob R
|
|
|

 

[Ron Rosenfeld]

Hello, I have Excel 2003 and Windows XP Pro.

I use this formula and it works exactly like I want it to except::

=IF(AC8<AC7,"YES Credit for " & "$" & AC8,"NO Max Credit for " & "$" & AC7)

AC8 and AC7 are both currency values and I get formatting of it like this
$133
$133.1
$133.10

I would always like to return a full currency value like the $133.10 but
can't figure it out. The two cells are both formatted in currency and
display two decimal places

Anyone have any ideas that it will format each time??
Thanks
Bob R

Use the TEXT worksheet function to format the result:

=IF(AC8<AC7,"YES Credit for " & text(ac8,"$#,##0.00"),"NO Max Credit for " &
text(ac7,"$#,##0.00"))

or similar
--ron

 

[LabrGuy Bob R]

Many thanks to all of you for helping me out, my problem is solved once
again.
Appreciate the assistance

BOB

 

[Guest]

=IF(A8<A7,"YES Credit for "&DOLLAR(A8,2),"NO Max Credit for "&DOLLAR(A7,2))

 

[LabrGuy Bob R]

=IF(AC8<AC7,"YES Credit for " & text(ac8,"$#,##0.00"),"NO Max Credit for " &
text(ac7,"$#,##0.00")) ac8-ac7,"$#,##0.00

=IF(AC8<AC7,"YES Credit for "&TEXT(AC8,"$#,##0.00"),"NO Max Credit for
"&TEXT(AC7,"$#,##0.00"))
AC8-AC7
=IF(A8<A7,"YES Credit for "&DOLLAR(A8,2),"NO Max Credit for "&DOLLAR(A7,2))
A8-A7

All three worked and very well, EXCEPT I now have formulas that use the
addition or subtraction of A8-A7 OR A8+A7, as I indicated above. I can't get
it to work probably because I would think I need to make the calculation in
another cell and only reference that cell. I've tried to put it in the
formula like I did above but it won't work. Probably because it's text and I
can perform math on text...

Any ideas.
Thanks
BOB

 

[Pete_UK]

I don't quite understand. You could still subtract AC7 from AC8 (or is
it A7 from A8 ?), as they are not affected by the formula. You can
have something like:

.... & TEXT(AC8-AC7,"#,##0.00") ...

within your formula if you need to subtract them and build them into a
text message as before.

Hope this helps.

Pete

 

[LabrGuy Bob R]

That's funny, just as I went to post that I found there was an issue with my
formatting and that the probelm wasn't really real you confimed what I have
read other places. thanks for taking the time, it's appreciated. The issue
was at my end so problem fixed....
Thanks
BOB

 

[Pete_UK]

Okay, thanks for feeding back.

Pete

That's funny, just as I went to post that I found there was an issue with my
formatting and that the probelm wasn't really real you confimed what I have
read other places. thanks for taking the time, it's appreciated. The issue
was at my end so problem fixed....
Thanks
BOB









- Show quoted text -