operator

Is there any way I can use Like to determine if a string starts with "[" and ends with "]"? Or another (better?) method than left,1 and right, 1 ?

I was going to quickly mock up some logic in excel for another project I'm working on and ran into a problem I cant solve without creating dependency loops. I'm looking for a less than comparison with a bias: =IF(X1"<"Y1,1,0) and would remain true until: =IF(X1">"Y1+B1,1,0) Here is as close as...

we are going to a new pay system. Instead of just a standard hourly wage, employees will be able to make a higher wage based on the production of the plant they work at. I am looking for help with a formula that will assign the new wage per hour based on the level of the employee and the amount...

Dear Great Minds of Excel, Is it possible to use a variable to represent an operator. For example, in an if then statement I want the operator to be able to be changed based on a users input. Can I replace >= with Oprtr after defining Oprtr as ">="? Dim Oprtr OprtrA = ">=" OprtrB = "<="...

<tbody> Mar Apr May Jun Jul Aug Sept Oct Nov Dec Total Ops 5 10 15 20 25 30 35 40 45 50 275 Case/Month 4 8 12 16 20 24 28 32 36 40 220 Total Cases 20 80 180 320 500 720 980 1280 1620 2000 7700 </tbody> Above is the problem I am working on: We are assuming we can get 5 new operators per...

I'm trying to incorporate a new feature into an already existing spreadsheet I maintain, but I'm having trouble finding the right functions and/or logic. Basically, I'm trying to give the user a column (in this case, B, in the table below), which will allow the value in Column C to be modified...

I am wondering for Identify Indian Mobile Number from the List of Numbers in Column. Now, I have made a formula to identify the mobile number which closer to correct but not 100% correct if any body have better idea to have the formula more accurate without using any look up or Database...

Can this be done? Is it possible to name a comparative operator such as ">=2" and use it as part of an array formula? I have tried syntax after syntax and nothing seems to work.