# modify formula

1. ### 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. ### 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. ### 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. ### 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. ### 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. ### 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.

### Which adblocker are you using?

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

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