AND Formula in Macro VBA

[NYEXCEL1]

In the below Macro, specifically the section in red, i am trying to and an AND formula but do not know how.

In short, when the value is evaluated and it matches the "" "" format as shown, i need add a condition that say if the number in the cell with the offset of -5 of the row is 5080 then print word "NOTHING" otherwise "NONEED".

I thought maybe eliminating the first if statement (in red) and adding separate if statement just for this double condition would be easier but it didnt work. Really appreciate any help in getting this to work. Many thanks!!


Any help here would be great and if i am overthinking this


Sub Nyexcel2()
With Range("I4", Range("B" & Rows.Count).End(xlUp).Offset(, 7))
.Value = Evaluate(Replace("if((@ ="" ""),""NONEED"",if((@ =""""),"""",2010))", "@", .Offset(, -7).Address))
End With
End Sub

 

[footoo]

The first criterion is looking for a single space (i.e. " ") in column B. Is that what you want?

 

[NYEXCEL1]

Yes, then in Column D there is a 4 digital code. if the number is 5080 then print "NOTHING" otherwise "NONEED"

thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1100875-compile-error-post5293365.html#post5293365

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).