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]

if you look here you can get a download for displaying on MrExcel

 

[Scott Huish]

Answer received in duplicate post. Closing this thread.