function edit()

  1. M

    SumIFs Problem

    I want to give sum of working time at Time Period from Date N1 to Date O1. formula writes in N2 Cell. This is Formula : =SUMIFS($J:$J,$L:$L,1,$B:$B,B3,$F:$F,$N$1,$F:$F,$O$1) what is problem answer is zero <tbody> <colgroup><col span="2"><col><col><col><col><col><col><col><col><col><col><col...
  2. S

    Help with creating excel function

    Hey Guys, I am very new to creating functions using Microsoft VBA and hence need your help for the same. I want to create a function which should perform the operation mentioned below. Function IDW(StartValue, EndValue, CurrentPoint) IDW = (StartValue * (Row(EndValue) - Row(CurrentPoint)) +...
  3. B

    How to convert this formula into a custom Function??

    "=MID(J2;FIND("@";J2)+1;LEN(J2)-FIND("@";J2)-(LEN(J2)-FIND(".";J2;FIND("@";J2)))-1)" I have made this formula to extract the domain from an email, i mean it takes anything after the "@" and before the final dot. What i want to do is to add this to an Add-in like a custom function i.e...
  4. J

    Openform multiple where statements

    Hi I have an openform method in a form and I wish to have multiple where conditions however it is not working. This is the code that I have at present Function edit() Dim teama As String Dim clause As String Dim dat As Date teama = Forms![Edit_Entries_Form]![Combo5].Value dat =...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top