Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if then statement help
Hello-
I have the following info in excel and I need code to place an "X" in column J if the conditions are met, then continue searching down the sheet for similar instnaces and dropping X's in column J where appropriate. A B C D E F G H J RING 532 0 n n n n ACD IN 532 254 n n n n AVAIL 0 0 n n n n RING 532 0 n n n n ACD IN 532 3 n n n y IF Range("h5").value = "y" AND Range("d5").value < 10 AND range("a4").value = "ring" Then .Range("j5").value = "X" Thanks- Scott |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if then statement help
If that's all there is to it, the following should do:
Sub X() If Range("H5").Value Like "y" And Range("D5").Value < 10 And _ Range("A4").Value Like "RING" Then Range("J5").Value = "X" End Sub "Sabosis" wrote: Hello- I have the following info in excel and I need code to place an "X" in column J if the conditions are met, then continue searching down the sheet for similar instnaces and dropping X's in column J where appropriate. A B C D E F G H J RING 532 0 n n n n ACD IN 532 254 n n n n AVAIL 0 0 n n n n RING 532 0 n n n n ACD IN 532 3 n n n y IF Range("h5").value = "y" AND Range("d5").value < 10 AND range("a4").value = "ring" Then .Range("j5").value = "X" Thanks- Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
Embedding an OR statement in an IF statement efficiently | Excel Discussion (Misc queries) | |||
Can an If statement answer an If statement? | Excel Discussion (Misc queries) | |||
appending and IF statement to an existing IF statement | Excel Worksheet Functions |