Hi Experts,
I need to update column B basis the value of Column A using VBA code
i.e If A1 has positive value then B1 to be updated as Positive similarly if A2 has negative value B2 to be updated as Negative.
Is there any way other then using IF condition like =if(A1>0,"Positive","Negative) in VBA function.
Regards,
Prabhu
Bookmarks