"IF" question
 

help please

i got below condition

A B
acondDD 102
bcond 10
acondDD 204
bcond 20
acondDD AA
acondDD BB

for any acondition with numbers in column B,
i want it to say "1"
for any bcondition with numbers in column B,
i want it to say "3"
for any acondition with letters in comumn B,
i want it to say "5"

i know it's wrong but i wrote something like
=IF(LEFT(A1,7)="acondDD" & ISNUMBER(-RIGHT(A1,4),"1",LEFT(A1,7)="acondDD" &
RIGHTA(A1,2),"3",(LEFT(A1,5)="bcond" & RIGHT(A1,2),"5"))))

What can i do with this formula or do i need something totally different?
please enlighten me!!!

thanks!!!!!!

"IF" question
 

Try this formula in C-column
C2=IF(AND(A2="aconddd",ISNUMBER(B2)),1,IF(AND(A2=" bcond",ISNUMBER(B2)),3,5))
With regards
Sreedhar
"doyree" wrote:

help please

i got below condition

A B
acondDD 102
bcond 10
acondDD 204
bcond 20
acondDD AA
acondDD BB

for any acondition with numbers in column B,
i want it to say "1"
for any bcondition with numbers in column B,
i want it to say "3"
for any acondition with letters in comumn B,
i want it to say "5"

i know it's wrong but i wrote something like
=IF(LEFT(A1,7)="acondDD" & ISNUMBER(-RIGHT(A1,4),"1",LEFT(A1,7)="acondDD" &
RIGHTA(A1,2),"3",(LEFT(A1,5)="bcond" & RIGHT(A1,2),"5"))))

What can i do with this formula or do i need something totally different?
please enlighten me!!!

thanks!!!!!!

"IF" question
 

Try this:
=IF(LEFT(A7,7)="acondDD",IF(ISNUMBER(B7),"1","5"), IF(LEFT(A7,5)="bcond",IF(ISNUMBER(B7),"5","otherwi se")))

"otherwise" stands for case
"for any bcondition with NOT numbers in column B" not stated by you!

Regards,
Stefi


€ždoyree€� ezt Ã*rta:

help please

i got below condition

A B
acondDD 102
bcond 10
acondDD 204
bcond 20
acondDD AA
acondDD BB

for any acondition with numbers in column B,
i want it to say "1"
for any bcondition with numbers in column B,
i want it to say "3"
for any acondition with letters in comumn B,
i want it to say "5"

i know it's wrong but i wrote something like
=IF(LEFT(A1,7)="acondDD" & ISNUMBER(-RIGHT(A1,4),"1",LEFT(A1,7)="acondDD" &
RIGHTA(A1,2),"3",(LEFT(A1,5)="bcond" & RIGHT(A1,2),"5"))))

What can i do with this formula or do i need something totally different?
please enlighten me!!!

thanks!!!!!!

"IF" question
 

stefi, thank you so much for your formula.

i have another question regards to below.

say, if those 2 columns were combined into 1,

all conditions and numbers were in 1 column,


=IF(LEFT(A7,7)="acondDD" &
VALUE(RIGHT(ISNUMBER(A7),4),"1",IF(LEFT(A7,7)="aco ndDD" &
RIGHT(ISTEXT(C2),4),5,"otherwise")))

could you tell me how i can revise this formula or
totally rewrite this please?

thank you.
p.s.
above is just "aconDD" no "bcond" of course



"Stefi" wrote:

Try this:
=IF(LEFT(A7,7)="acondDD",IF(ISNUMBER(B7),"1","5"), IF(LEFT(A7,5)="bcond",IF(ISNUMBER(B7),"5","otherwi se")))

"otherwise" stands for case
"for any bcondition with NOT numbers in column B" not stated by you!

Regards,
Stefi


€ždoyree€� ezt Ã*rta:

help please

i got below condition

A B
acondDD 102
bcond 10
acondDD 204
bcond 20
acondDD AA
acondDD BB

for any acondition with numbers in column B,
i want it to say "1"
for any bcondition with numbers in column B,
i want it to say "3"
for any acondition with letters in comumn B,
i want it to say "5"

i know it's wrong but i wrote something like
=IF(LEFT(A1,7)="acondDD" & ISNUMBER(-RIGHT(A1,4),"1",LEFT(A1,7)="acondDD" &
RIGHTA(A1,2),"3",(LEFT(A1,5)="bcond" & RIGHT(A1,2),"5"))))

What can i do with this formula or do i need something totally different?
please enlighten me!!!

thanks!!!!!!

"IF" question
 

Maybe you need this:
=IF(LEFT(A2,7)="acondDD",IF(ISNUMBER(VALUE(RIGHT(A 2,4))),"1","5"),"otherwise")
Stefi


€ždoyree€� ezt Ã*rta:

stefi, thank you so much for your formula.

i have another question regards to below.

say, if those 2 columns were combined into 1,

all conditions and numbers were in 1 column,


=IF(LEFT(A7,7)="acondDD" &
VALUE(RIGHT(ISNUMBER(A7),4),"1",IF(LEFT(A7,7)="aco ndDD" &
RIGHT(ISTEXT(C2),4),5,"otherwise")))

could you tell me how i can revise this formula or
totally rewrite this please?

thank you.
p.s.
above is just "aconDD" no "bcond" of course



"Stefi" wrote:

Try this:
=IF(LEFT(A7,7)="acondDD",IF(ISNUMBER(B7),"1","5"), IF(LEFT(A7,5)="bcond",IF(ISNUMBER(B7),"5","otherwi se")))

"otherwise" stands for case
"for any bcondition with NOT numbers in column B" not stated by you!

Regards,
Stefi


€ždoyree€� ezt Ã*rta:

help please

i got below condition

A B
acondDD 102
bcond 10
acondDD 204
bcond 20
acondDD AA
acondDD BB

for any acondition with numbers in column B,
i want it to say "1"
for any bcondition with numbers in column B,
i want it to say "3"
for any acondition with letters in comumn B,
i want it to say "5"

i know it's wrong but i wrote something like
=IF(LEFT(A1,7)="acondDD" & ISNUMBER(-RIGHT(A1,4),"1",LEFT(A1,7)="acondDD" &
RIGHTA(A1,2),"3",(LEFT(A1,5)="bcond" & RIGHT(A1,2),"5"))))

What can i do with this formula or do i need something totally different?
please enlighten me!!!

thanks!!!!!!