If and then

[joacro]

Hi there I wonder if anyone can help me with this.

I need VBA code for:

If Range(F2)greater or equal to 90000 and (H2) = 90000 the (J2) ="Gold'
else if (F2) = smaller than 90000 but greater or equl to 70000 and H2 = 90000 the H2 = Silver


Hope this makes sense and that someone can help me

Regards
Joacro

 

[texasalynn]

try this

Sub Gold_Silver()
If Range("H2") = 9000 And Range(F2) >= 90000 Then
    Range("J2") = "Gold"
End If
If Range("F2") < 9000 Or Range("F2") >= 7000 And Range("h2") = 90000 Then
    Range("H2") = "Silver"
End If
End Sub

 

[VoG]

Try

If Range("F2").Value >= 90000 And Range("H2").Value = 90000 Then
    Range("J2") = "Gold'"
ElseIf Range("F2").Value <= 90000 And Range("F2").Value >= 70000 And Range("H2").Value = 90000 Then
    Range("H2").Value = "Silver"
End If

 

[joacro]

Hi there guys,

It doesn't seem to work. However F2 is merged From F2 to F5 the same with H and J

Can you please advice accordingly

Regards

Joacro

 

[VoG]

Merged cells and VBA do not mix well. Try this http://www.mrexcel.com/forum/showthread.php?t=335123

 

[joacro]

Hi there Peter,

I have unmerged the cell but is still doesn't seem to work.

I have pasted you code to the vba in the sheet that I want the code to work on.

Any advise?

 

[texasalynn]

post the data you have

 

[joacro]

How do I upload my file

 

[joacro]

Could you please upload me an example

 

[joacro]

Anyone please assist me in this

Regards