limit

Hi, I have the following formula: =IF(B3<=100000,0,IF(AND(B3>100000,B3<=250000),E3*0.06%, IF(AND(B3>250000,B3<=1000000), E3*0.1%, IF(AND(B3>1000000,B3<=5000000), E3*0.15%, IF(B3>5000000, E3*0.19%))))) I want to limit the value it returns to be no greater than 15000, how do I do that. Thanks

Hi, i have formula in data validation list like here...

Dears, I have done a workbook with about 20 pages, with several names and formulas, most of them "IF" like. After close and open the file/workbook, I notice several formulas absent, from the cell, or printed in the cell, one of 2 possible results. NAD ADQ. Anyone knows if there are a limit in...

Is there a limit to the SUMPRODUCT? This fails: Dim LastRow as Integer LastRow = 1000 Dim a As Variant With Sheet1 a = Evaluate("=SUMPRODUCT((-1*('" & .Name & "'!AN2:AN" & LastRow & "+'" & .Name & "'!AR2:AR" & LastRow & ")/'" & .Name & "'!H2:H" & LastRow & "/12<=" &...

Hi! I have this really long Excel formula that I need to add to my VBA but for some reasons, it feels like there is a length limit for Excel formulas in VBA? Thanks

Hi all, I've been running a VBA macro dealing with 2 xls sheets, one with approx 15,000 rows, and one with now over 30,000 rows. Somewhere between 30,000 and 30,700 I am now up to, the part of my macro which concatenates the 30,000 row spreadsheet and then pastes into the 15,000 row spreadsheet...

I have a excel file with about 1000 Rows and a single column, each cell contains a similar example: Cell A1 (INSPECTION RESULT: /(1)FACE "AA" GALLED, EXCEED EM LIMIT (0.010" MAX.). /( EXISTING: UP TO 0.037" APPROX. /(2)FACE "AD" GALLED, EXCEED EM LIMIT (0.010" MAX.). /( EXISTING: UP TO 0.030"...

Hi I'm trying to create a formula which limits its self at a certain value, the formula I am using up to now works fine however I need it to limit its self to a maximum value of 845. =IF(B14>MIN(200)*OR(MAX(1500)),((B14-200)/100)*65,0) any suggestions on how to do this? thanks

One of these days I was using INDEX+MATCH function in a large table (7800 rows and 30 columns) and one doubt came to my mind: - In terms of CPU workload, memory, excel etc, is there any difference between INDEX(table_column C:C!;MATCH(1;(table_column F:F!!=xpto....) and INDEX(table_column...

Hi everyone, first of all sorry for my english. I am here because i have a problem that need to be solved because is for work and i dont´t know how to make it happen. I am developing a worksheet that have several sheets that contain a table. All the 4th sheets have the same table, with the same...

I'm doing a little re-engineering of my personal add-in module. I am making changes to several functions. Some of these are incompatible with way the function used to work. I don't know where all of the function calls are (which workbooks and sheets), so I am putting MsgBox calls to tell the...

I need to add an additional IF statement to a cell where I already have an IF statement. I need to add an additional IF statement to the below that states if A31="Destination Handling" then set a minimum limit value of 100 and a maximum limit value of 550 to P31, otherwise, use the below IF...

Hi, I was wondering if there is a way to limit how many copies you can make of an excel file(xlsx or xlsm). (i.e. limit # of copy+paste operations carried out on a file) Thanks, Sj

I am looking for a VBA solution to limit the number of cells that can be copied at one time within a workbook. The data contains emails and I am needing to secure them to where only one can be selected at any given time. Any solutions?

Hello! I'm using Excel for Mac 2017 Version 15.41. I'm running into an issue I don't understand using conditional formatting. I'm attempting to highlight a row one of three different colors depending on a specific condition. I have an upper limit, lower limit, and an age. If the age is below...

I have a table that contains Limits($), Zones and the resulting charge amount. <tbody> A B C D E 1 Limit $10000 $15000 $20000 $25000 2 Zone 1 $10 $20 $30 n/a 3 Zone 2 $10 n/a n/a n/a </tbody> I have the above table. I want to pass in a zone number and a limit amount. If the...

Hello, I am looking preparing a tool which helps in getting value based upon certain clauses provided below : If X= 500$ Y = 1 (Frequency for time period in months). Z=500$/2 and Z > 200$ then Z should be Maximum limit of "200$" per 1 month. In other case, If X=500$ Y= 2 Z= 500$/2 and Z>400$...

I have invoice amounts in column A and approvers names on corresponding cell in column B, we have more than one approvers depending on the amount in column B. I arranged the approvers names in column C and the upper limit of amount they can approve in corresponding column D. the last name in...

Hi All, I have a large report that I am building a dashboard for with slices, it looks great and manageable when I filter the pivot tables to show the top 20 rows but when I use the slices on the dashboard the charts show all the data and it is impossible to visualize properly. Does anyone...

Anybody know of a workaround with the salesforce report query source 2000 row limit? I can't use the salesforce objects because I don't have developer access permissions and the current objects and field relationships don't mesh well, no record id to merge object queries.