Prev: what function to use?
Next: create a button to print certain tabs in excel 2003
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:340DE78A-749E-4791-9579-285250533419(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:845C88D1-F217-4E0F-889E-84AAAD7FA35C(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