How to write these function into a macro

[pogo123]

Hi guys,

May you guys help me on this as I want write this set of function in to macro. Many thanks

Function =if((and(sheet1!A2=Sheet3!$b$1,sheet1!j2=sheet3!$b$2,sheet1!u2=sheet3!$b$6)),(if(or(sheet1!j2="a",sheet1!j2="b",sheet1!j2="c"),sheet1!bn2,sheet1!bo2)),"")

Many Thanks

 

[James006]

Hello,

As an initial step ...

1. Turn on your macro recorder ...

2. Type your function in any cell ...

3. You will get a "VBA translation " ... which can ... then ... be improved ...

Hope this will help