IF and Left

[valemarje]

I currently use the formula

Range("D2").Select
ActiveCell.FormulaR1C1 = _
"=IF(LEFT(RC[-2],5)=""DAVID"",""DAVIDE"","""")))))"

but I would like to be able to put something like this, only I don't know the correct way:

If Range(B2).value (LEFT(RC[-2],5) = "DAVID"
Range("D2").value ="DAVIDE"
else
Range("D2").value =""
end if

Can you help me?

 

[Joe4]

Welcome to the Board!

Is this what you are looking for?

If Range("B2").Value = "DAVID"
    Range("D2").Value ="DAVIDE"
Else
    Range("D2").Value =""
End if

If so, why even bother adding nothing to cell D2, instead of just doing nothing to it, i.e.

If Range("B2").Value = "DAVID"
    Range("D2").Value ="DAVIDE"
End if

 

[valemarje]

thanks

 

[Joe4]

You are welcome.

Is that what you were looking for?

 

[valemarje]

but i need whit if...

IF(LEFT(RC[-2],5) not only
If Range("B2").Value = "DAVID"

 

[Joe4]

IF(LEFT(RC[-2],5) not only
If Range("B2").Value = "DAVID"

That does not make any sense. You cannot move two columns to the left of column B. That would take you off of the page.

Can you just explain in plain English what you are trying to do?

 

[valemarje]

In column B there are alphanumeric codes... depending on how they start in the corresponding line in column D I have to put a word that will be my category

So I made the example if the code in B2 starts with DAVID (example) in D2 I will put DAVIDE
If the code in B3 starts with MIS I will put "MIXER" in D3
If the code in B4 starts with MISS I will put "MISSION" in D4
etc...

 

[Joe4]

In column B there are alphanumeric codes... depending on how they start in the corresponding line in column D I have to put a word that will be my category

So I made the example if the code in B2 starts with DAVID (example) in D2 I will put DAVIDE
If the code in B3 starts with MIS I will put "MIXER" in D3
If the code in B4 starts with MISS I will put "MISSION" in D4
etc...

Then it should just be something like this:

If Left(Range("B2").Value, 5) = "DAVID"
    Range("D2").Value ="DAVIDE"
End if

if you want to hard-code the value into column D instead of inserting a formula.

 

[valemarje]

sul cellulare semplice penso che funzioni ed è esattamente quello che volevo quindi ti ringrazio.

come faccio a dirgli di ripetere per ogni riga da B2 a B6000, ad esempio?
e mettere i dati corrispondenti da D2 a D6000?

 

[valemarje]

on the simple cell I think it works and that is exactly what I wanted so I thank you.

how do i tell it to repeat for each row from B2 to B6000 row for example?
and put the corresponding data from D2 to D6000?