Nested IF function not working

[otisvillain]

Hey all,

I've tried my nested IF function about 10 different ways and it just isn't working. My data set is related to columns B (Insurance Plan Name) & C (Finance Class). My first IF function, only using 1 argument, works fine and is as follows:

=IF($B$1:$B$7000="EMPIRE BCBS BLUE CARD PROGRAM", "COMMERCIAL",$B$1:$B$7000)

For my nested IF function, I want the formula to evaluate the same data set, but also include "HIGHMARK BCBS" in the search. This is how I wrote the nested function, which is not working:

=IF($B$1:$B$7000=EMPIRE BCBS BLUE CARD PROGRAM,"COMMERCIAL",IF($B$1:$B$7000=HIGHMARK BCBS,"COMMERCIAL"))

Any suggestions?

Thank you

 

[CharlesChuckieCharles]

Some VBA to do whats required

Sub CheckCommercial()
Dim MyCell As Range
Dim MyDepth As Long
MyDepth = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row
For Each MyCell In ActiveSheet.Range("B1:B" & MyDepth)
   If MyCell.Value = "EMPIRE BCBS BLUE CARD PROGRAM" Or MyCell.Value = "HIGHMARK BCBS" Then
     MyCell.Offset(0, 1).Value = "COMMERCIAL"   'update column one to the right  ("C")
   End If
   DoEvents ' release to op system
Next MyCell

End Sub

 

[otisvillain]

Some VBA to do whats required

Sub CheckCommercial()
Dim MyCell As Range
Dim MyDepth As Long
MyDepth = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row
For Each MyCell In ActiveSheet.Range("B1:B" & MyDepth)
   If MyCell.Value = "EMPIRE BCBS BLUE CARD PROGRAM" Or MyCell.Value = "HIGHMARK BCBS" Then
     MyCell.Offset(0, 1).Value = "COMMERCIAL"   'update column one to the right  ("C")
   End If
   DoEvents ' release to op system
Next MyCell

End Sub

Thank you for your help! I will use this, and will update you on the result