| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
