Calculate cell numbers only not letters

[LuckyD]

In cell K17 I have 2

In cell L16 I have Volume x5

In cell L17 I have =K17*L16

In cell L17 I get #VALUE!
I want L17 to read 10.
I have tried =K17*INT(L16) which didn't work.
I just want it to calculate only the numbers in cell L16.

Thanks

 

[Smitty]

Welcome to the Board!

Not advisable, but

=K17*RIGHT(L16,LEN(L16)-FIND("x",L16))

should work (privoded the number is always prefaced by an "x").

If you can swing it, keep the Volumn Amount in a separate cell. It greatly simplifies things.

Hope that helps,

Smitty

 

[LuckyD]

Wow more complicated then I figured. In my basic programming class like 5 years ago it was easy to seperate integers from strings.

 

[Yogi Anand]

Hi Lucky:

For your entries in cells K17 and L16 as you have posted ...

in cell L17, you can use the formula ...

=K17*RIGHT(L16)
or
=K17*SUBSTITUTE(L16,"x","")

If you need a more general solution you have to provide better specification for possible entries in cell L16.

 

[Nimrod]

LuckyD
Another method would be to Custom format cell L16 with the format x#
When you put the number 5 in the cell the view you be x5. Doing this way will allow you to use your original formula.

 

[LuckyD]

Thanks for all your help

This will greatly improve my ability to quick change my volumes and concentrations.