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