RLLD 4,275 Posted March 1, 2007 I want to have a line of text in Excel with numeric entries throughout which are referenced from other cells. That way when China changes its focking with-holding tax again it can change my financial analsys in each text cell automatically. I thought I couls do it using the &B13& for example, but the format is wrong. Showing 0.10 instead of 10% Share this post Link to post Share on other sites
KSB2424 3,174 Posted March 1, 2007 Create a macro? ETA: nevermind, read that wrong. Hold on a minute. Share this post Link to post Share on other sites
RLLD 4,275 Posted March 1, 2007 Create a macro? ETA: nevermind, read that wrong. Hold on a minute. Beats me. I was just looking for a way to type a cell location within my line of text. I have seen it done before, but cannot remember how... Share this post Link to post Share on other sites
KSB2424 3,174 Posted March 1, 2007 Are you putting quotes around the text portion? Example: A1 = China B2 = 0.20 Formula: =A1&"tax witholding has changed to"&TEXT(B2,"0%") Should equal to: China tax withholding has changed to 0.20% maybe? Share this post Link to post Share on other sites
RLLD 4,275 Posted March 1, 2007 I may have figured out, usung the &Parameters! command...testing it now Share this post Link to post Share on other sites
Electric Mayhem 35 Posted March 1, 2007 the "&" is correct, but you have to tweak the numbers in between the text portions. if you want to say : China sucks, it has xMM in USD riding on mink farms, which is y% of their total GNP where x = 10,000,000 in cell B1 and y = .22345 in cell C1 You would put: ="China sucks, it has "&(B1/1000000)&"MM in USD riding on mink farms, which is "&(round(c1*100,0))&"% of their total GNP" Share this post Link to post Share on other sites
RLLD 4,275 Posted March 1, 2007 Nice explanation EM. I was just checking back to say that THIS got me what I wanted.... =" The Rate of "&TEXT(B13,"%00")&"" Are you putting quotes around the text portion? Example: A1 = China B2 = 0.20 Formula: =A1&"tax witholding has changed to"&TEXT(B2,"0%") Should equal to: China tax withholding has changed to 0.20% maybe? Yes, while I did figure it out myself, this is exactly what I was looking for. Thanks guys.... Share this post Link to post Share on other sites
Toro 3 Posted March 1, 2007 ='Go Fock Yourself'$F$69 * 'Your Mom'$DD$38 Share this post Link to post Share on other sites
resser2 0 Posted March 1, 2007 the "&" is correct, but you have to tweak the numbers in between the text portions. if you want to say : China sucks, it has xMM in USD riding on mink farms, which is y% of their total GNP where x = 10,000,000 in cell B1 and y = .22345 in cell C1 You would put: ="China sucks, it has "&(B1/1000000)&"MM in USD riding on mink farms, which is "&(round(c1*100,0))&"% of their total GNP" wow thanks, I learned something too Share this post Link to post Share on other sites
RLLD 4,275 Posted March 1, 2007 Check out how the computation of weighted average looks in this kind of construct... "&TEXT(((B13*(1-B17))*B15)+(B14*B16),"0.00%")&"" Share this post Link to post Share on other sites
Electric Mayhem 35 Posted March 1, 2007 Check out how the computation of weighted average looks in this kind of construct... "&TEXT(((B13*(1-B17))*B15)+(B14*B16),"0.00%")&"" That doesn't look liek a weighted average. I would think it would be more along the lines of ((B13*B15)+(B14*B16))/(B13+B14). Unless your 'weights' are constant (B13 & B14). Still trying to figure out why you need the inverse % of B17 in the equation... Share this post Link to post Share on other sites
