Using IF....Else IF

SAMCRO2014

Board Regular
Joined
Sep 3, 2015
Messages
160
I am trying to get a loop to return a value (Previous or Current) when looking through a column. My coding is returning "Previous" when it should be "Current" and vice versa. Also, I am trying to get it to return a value (Current) if a string of text in a cell contains the word "Error".

So if the cell :
contains the word "Error" in it =Current
value is > 201814 = Current
all other cells =Previous

This is what I have

For f = 2 To LastRowData


If Cells(f, 12).Value = "*Error*" Then
Cells(f, 13) = "Current"
ElseIf Cells(f, 12).Value > "201814" Then
Cells(f, 13) = "Current"
Else: Cells(f, 13) = "Previous"

End If

Next f

Thanks!
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
In col L are the values numbers or text?
Also when you have "Error" is it exactly like that or could it be "error", or maybe "ERROR"?
 
Upvote 0
The values are both numbers and text.

The wording in some cells is Error 4_PRI LOCKED_P04. This will change monthly. The consistent word is Error.
 
Upvote 0
How about
Code:
For f = 2 To LastRowData
   
   
   If Cells(f, 12).Value Like "*Error*" Then
      Cells(f, 13) = "Current"
   ElseIf Cells(f, 12).Value > 201814 Then
      Cells(f, 13) = "Current"
   Else: Cells(f, 13) = "Previous"
   
   End If

Next f
 
Upvote 0

Forum statistics

Threads
1,223,886
Messages
6,175,196
Members
452,616
Latest member
intern444

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top