From: Glenn on 11 Mar 2010 11:56 DaveR wrote: > I have a formula in cell G13 that shows "=B13*C13". Is there a way that i > can multiply cell B13 which has a number format and reads "61 Units" to cell > C13 which has a currency format and contains "34.23 / Ea" to get a value of > $2,088.03 shown in cell G13? I don't know if I can show text in the cell > that is being referenced in a formula. > > Can you show text in a cell that is being referenced in a formula without > receiving the "#value!" in the formula cell? > > Thanks. Another way: =LEFT(B13,FIND(" ",B13)1)*LEFT(C13,FIND(" ",C13)1)
From: Bob Phillips on 11 Mar 2010 12:57 But yours is a better way. I also thought of suggesting that, but just decided to give him a 'straight' answer :)  HTH Bob "pmartglass" <pmartglass(a)discussions.microsoft.com> wrote in message news:340DE78A749E47919579285250533419(a)microsoft.com... >I like that > > "Bob Phillips" wrote: > >> Try >> >> =SUBSTITUTE(B13," Units","")*SUBSTITUTE(C13," / Ea","") >> >>  >> >> HTH >> >> Bob >> >> "DaveR" <DaveR(a)discussions.microsoft.com> wrote in message >> news:845C88D1F2174E0F889E84AAAD7FA35C(a)microsoft.com... >> >I have a formula in cell G13 that shows "=B13*C13". Is there a way that >> >i >> > can multiply cell B13 which has a number format and reads "61 Units" to >> > cell >> > C13 which has a currency format and contains "34.23 / Ea" to get a >> > value >> > of >> > $2,088.03 shown in cell G13? I don't know if I can show text in the >> > cell >> > that is being referenced in a formula. >> > >> > Can you show text in a cell that is being referenced in a formula >> > without >> > receiving the "#value!" in the formula cell? >> > >> > Thanks. >> >> >> . >>
First

Prev

Pages: 1 2 Prev: what function to use? Next: create a button to print certain tabs in excel 2003 