"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!!!!!!
|