Conditional formula with text and number in cell
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
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.
.
|