------------------------------------
Step 1- Just Open MS Excel firstly.
Step 2- Press Alt+F11.
Step 3- Choose Insert Option from menubar.
Step 4- Select Module Option.
Step 5- Write the Following Code.
Public Function Cat_Sum( a as integer, b as integer)
Cat_Sum = a + b
End Function
Step 6- Just save the file.
Step 7- Again Press Alt+F11 to go back in MS Excel.
Now you can use your function by this syntex...
Supoose you have inputed 30 in first Row of Cell A and 20 in first Row of cell B.
= Cat_Sum(A1,B1) type same syntex at Formula bar and press Enter.
Step 1- Just Open MS Excel firstly.
Step 2- Press Alt+F11.
Step 3- Choose Insert Option from menubar.
Step 4- Select Module Option.
Step 5- Write the Following Code.
Public Function Cat_Sum( a as integer, b as integer)
Cat_Sum = a + b
End Function
Step 6- Just save the file.
Step 7- Again Press Alt+F11 to go back in MS Excel.
Now you can use your function by this syntex...
Supoose you have inputed 30 in first Row of Cell A and 20 in first Row of cell B.
= Cat_Sum(A1,B1) type same syntex at Formula bar and press Enter.
Thanks for Distribution a Nice Post about Excel and I must Say it’s actually helpful for us. We Learn So Many Things through Your Post So Please Keep Going & Never Stop Your Writing
ReplyDeleteThere is lots of Writer but your writing way is so good and different. It’s really helpful for us and knowledgeable so thanks for sharing...
ReplyDeleteAdvanced Excel Training in Delhi
Advanced Excel Training in Noida
Advanced Excel Training in Gurgaon
I read Your Post and Trust me it’s really Nice Post with Lots of Knowledge
ReplyDeleteAdvanced Excel Training Institute in Delhi
I read Your Post and really its really Nice Article & Very Informative Post Otherwise if any One Want To Grow your Career in Advanced Excel So There are Some Top Best Training Center for excel & Advanced Excel institute
ReplyDeleteAdvanced excel course in Delhi
Advanced excel course in Noida
Advanced excel Training in Delhi
Advanced excel Training in Noida