modify formula

  1. T

    Roster Formula assistance.

    Hi. I need some help with a formula, please. see the below formula: =IF(OR(J$13="",J$13<$Q$8,$A14=""),"",IF(NETWORKDAYS.INTL(J$13,J$13,weekend,holidays)=0,0,IFERROR(INDEX(daysoff_type,MATCH(J$13&"...
  2. W

    specify gap size using Randbetween function

    How can RANDBETWEEN(1,850) be modified to select numbers <+8 or >-8 of the previous selection? Thanks, White Top
  3. L

    How to extract numbers from text with specified and unique conditions

    <quote> I was curious if someone could tell me how to change this formula and add some properties. Such as: To ignore number strings lead by zeros, if an x is directly behind a + = - its counted as a 1 is extrated (or in the case of the - a -1), and if a - is directly in front of a number...
  4. K

    Help! I am getting "you've entered too many arguments for this function- any ideas??

    Help. I am getting "you've entered too many arguments for this function". Does anyone know how to add more? I am trying to use: =IF(C5<1000001,C15,IF(C5<2000001,C17,IF(C5<3000001,C18,C19,C20,C21))) for the $1.5M , $4M & $5M option but it won't let me add C16, C20 & C21 for column one...
  5. S

    change the formula as it give all space after dot .

    if i run this formula i need the output with out space after dot , if input is without space, if there is space after dot in input ,then out put is with space after dot. need to change the formula as it give all space after dot . =UPPER(MID(TRIM(SUBSTITUTE(A1,".","...
  6. K

    Adding to existing formula

    I am trying to get user input from an input box and add that value to an existing formula. So far, I have been able to get the user input to work but am not sure how to add it to the formula. Dim strnewassembly As String strnewassembly = InputBox("Please enter the Assembly Number you would...

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
Back
Top