I'm looking for a formula that will take the value in Cell A1 and A2 and insert it into Cell B1 in the following format:
A1 Value / A2 Value.
A1 and A2 cells contain a dollar value.
Example:
A1 contains: $300.00
A2 contains: $400.00
I need a formula in Cell B1 that will return: $300.00 / $400.00
use text()
=TEXT(A1,"$0.00")&" / "&TEXT(A2,"$0.00")
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you. This did it for me. I needed to slightly modify the formula to provide the comma for those values that were greater than 1,000, but once I figured out how to do that, we're in business! Thank you again.
Be Well,
bwm
To add comma use this modified formula
=TEXT(A1,"$#,0.00")&" / "&TEXT(A2,"$#,0.00")
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thank you! That works even better than the modification I made to the formula!!
You're welcome and thank you for the feedback! Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks