Formating numbers &"Text" to appear as currency &"Text" in formula
 

Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D

Formating numbers &"Text" to appear as currency &"Text" in formula
 

" You owe me "&TEXT(A2-A1,"$#,##0.00")
etc.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Robin K." wrote in message
...
Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D

Formating numbers &"Text" to appear as currency &"Text" in formula
 

I don't have that kind of money to give away, but I can give you my
solution to your problem - use the TEXT function, like so:

=if(A1A2," You owe me "&TEXT(A2-A1,"$0.00"),if(A1<A2,"I owe you
"&TEXT(A1-A2,"$0.00"),"No outstandings"))

Hope this helps.

Pete

On May 2, 3:46 pm, Robin K. wrote:
Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D

Formating numbers &"Text" to appear as currency &"Text" in formula
 

=if(A1A2," You owe me "&TEXT(A2-A1,"$#,##0.00"),if(A1<A2,"I owe you
"&TEXT(A1-A2,"$#,##0.00"),"No outstandings"),"")

If you want to do the rounding up of .123 to .13, then include
ROUNDUP(...,2)
--
David Biddulph

"Robin K." wrote in message
...
Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D

Formating numbers &"Text" to appear as currency &"Text" in formula
 

try this

=IF(A1A2," You owe me " &DOLLAR(A2-A1),IF(A1<A2,"I owe you
"&DOLLAR(A1-A2),"No outstandings"))

"Robin K." wrote:

Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D

Formating numbers &"Text" to appear as currency &"Text" in formula
 

One mo

=IF(A1=A2,"No Outstandings",
IF(A1A2,"You owe me ","I owe you ")&TEXT(ABS(A1-A2),"$#,##0.00"))

(all one cell)

Robin K. wrote:

Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D

--

Dave Peterson

Formating numbers &"Text" to appear as currency &"Text" in formula
 

Thank you to Jon, Mike, Pete, David and Dave!

To reader,
If you find their replies helpful, please vote Yes! to them. Thank you.

"Robin K." wrote:

Hi,
There was no prior question to this issue. So I thought this would be a
challenge...

Using Windows XP with Excel 2003. The content of the cell is:
=if(A1A2," You owe me "&(A2-A1),if(A1<A2,"I owe you "&(A1-A2),"No
outstandings"),"")

Sample of outcome is
You owe me 556677.123

Would like the outcome to be
You owe me $556,677.13

Already tried changing cell format to Currency but still appears as sample
outcome. Thank you for all responses.

PS: A hearty appreaciation if anyone sends me $556,677.13 :D