Prev: countblank with sumproduct?
Next: Count number of people
From: RichM on 29 May 2010 14:47
Hello,

Can a conditional formula be written to convert a cell with text and a
number to a cellw ith just a number?

I have a cell with the number 10 and the word "weak" in it. 10 weak

Can a conditional formula convert this to just the number "10"? I did
=If(b1= 10 weak,"10") but it does not work.

Thank you.
From: Gord Dibben on 29 May 2010 15:10
=IF(B1="10 weak",10,"not 10 weak")

BTW............10 weak what's?

10 weak kittens?

10 weak cups of tea?


Gord Dibben MS Excel MVP

On Sat, 29 May 2010 11:47:01 -0700, RichM <RichM(a)discussions.microsoft.com>
wrote:

>Hello,
>
>Can a conditional formula be written to convert a cell with text and a
>number to a cellw ith just a number?
>
>I have a cell with the number 10 and the word "weak" in it. 10 weak
>
>Can a conditional formula convert this to just the number "10"? I did
>=If(b1= 10 weak,"10") but it does not work.
>
>Thank you.

From: Sheeloo on 29 May 2010 22:58
You can not use conditional formula to change values in a cell... you can use
it to format the cells meeting a condition..

Also you can not use a formula to change value in the same cell...

It you just want to remove " weak" then you can use find and replace...

"RichM" wrote:

> Hello,
>
> Can a conditional formula be written to convert a cell with text and a
> number to a cellw ith just a number?
>
> I have a cell with the number 10 and the word "weak" in it. 10 weak
>
> Can a conditional formula convert this to just the number "10"? I did
> =If(b1= 10 weak,"10") but it does not work.
>
> Thank you.
From: RichM on 30 May 2010 06:17
Thank you Gord. That did it. It's a 10-point Likert scale with 1=strong,
10=weak. Asking about belief in ability to solve science questions. Thanks
again.

"Gord Dibben" wrote:

> =IF(B1="10 weak",10,"not 10 weak")
>
> BTW............10 weak what's?
>
> 10 weak kittens?
>
> 10 weak cups of tea?
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 29 May 2010 11:47:01 -0700, RichM <RichM(a)discussions.microsoft.com>
> wrote:
>
> >Hello,
> >
> >Can a conditional formula be written to convert a cell with text and a
> >number to a cellw ith just a number?
> >
> >I have a cell with the number 10 and the word "weak" in it. 10 weak
> >
> >Can a conditional formula convert this to just the number "10"? I did
> >=If(b1= 10 weak,"10") but it does not work.
> >
> >Thank you.
>
> .
>
From: RichM on 30 May 2010 06:42
Hi Gord,

I hope you don't mind, one more question. I want to put a string of these
conditions together and did this: =IF(E2="5 okay/strong",5,"not 5
okay/strong",if(e2="10 strong",10,"not 10 strong",if(e2="1 weak",1,"not 1
weak")))

But it doesn't work. Can you tell me what would work? Thanks again for your
help.

"Gord Dibben" wrote:

> =IF(B1="10 weak",10,"not 10 weak")
>
> BTW............10 weak what's?
>
> 10 weak kittens?
>
> 10 weak cups of tea?
>
>
> Gord Dibben MS Excel MVP
>
> On Sat, 29 May 2010 11:47:01 -0700, RichM <RichM(a)discussions.microsoft.com>
> wrote:
>
> >Hello,
> >
> >Can a conditional formula be written to convert a cell with text and a
> >number to a cellw ith just a number?
> >
> >I have a cell with the number 10 and the word "weak" in it. 10 weak
> >
> >Can a conditional formula convert this to just the number "10"? I did
> >=If(b1= 10 weak,"10") but it does not work.
> >
> >Thank you.
>
> .
>
 |  Next  |  Last
Pages: 1 2
Prev: countblank with sumproduct?
Next: Count number of people