I am using a data table to calculate and display the result of multiple formulas. I just do not know how the format the result.
The reference cell of the data table links to two formulas using the formula =J20&"/"&J21.
That formula is than run through the data table and displays the result of both formulas. I need to format result one as a % and result two as a $. As of now the result looks like this
0.251329463720322/2.60201520561843
Any one have any idea?
post removed by user
Last edited by darknation144; 02-03-2012 at 12:14 PM.
Try:
=TEXT(J20,"0.00%")&"/"&TEXT(J21,"$#,##0.00")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks