nesting

  1. F

    Nested subtraction in SUMIFS

    Hi, I'm trying to populate a formula that sums all the sales of a particular item with few conditions: =SUMIFS(Table1[Sales New] - Table1[Sales Change]; Table1[Sales New] - Table1[Sales Change];">0";Table1[Sales New];">0";Table1[Item];"Blue shirt") --> Table1[Sales New]-Table1[Sales Change] =...
  2. S

    Nesting Sumproduct and Sumifs not working

    Hi I am trying to change this formula to use Sumifs to make it faster (trying to use better formulas to speed up my spreadsheet) but i cant seem to get it to work I am trying to do a multiple or with sumproduct my current formula...
  3. N

    Nesting LEFT into an OR formula

    Cheers! I'm trying to incorporate a LEFT function into the following formula so it will look at only the first two digits of CSV!J3 for the numbers 4,5,8,10,11. =IF(OR(CSV!J3={4,5,8,10,11}),((0.1005*TAN((PI()/180)*(90-(CSV!Z3/2))))-(0.0693*SIN((PI()/180)*(90-CSV!Z3/2))))*2,0) I tried...
  4. N

    Nesting 3 functions IFERROR, VLOOKUP, ISBLANK

    So I hope that I can explain this clearly. So I am trying to nest three formulas, IFERROR, VLOOKUP, ISBLANK. The goal that I am trying to achieve is use the vlookup function along with the IFERROR to not get N/A where there is nothing for the function to lookup. That has been achieved but, if...
  5. R

    Help make my formula work (please)

    =IF(I8="No"),((SUM('All Distrib'!J3:J810),If(I8="Yes"),(SUM('All Distrib'!J3:J810)*I$9)) I need this information but parentheses are wrong (sigh). Very bad at nesting. Help would be so lovely. Thank you!!!!!!!!!!!!!!
  6. M

    Formula uses more levels of nesting than allowed

    As you can see from the formula, I'm attempting to get point values from one time to the next in half-point increments. Not even halfway through the formula, I ran a test and it said there were too many levels of nesting. It will place the point values up to about the 9 point mark, but not...
  7. H

    Nesting Limit Hit Using IF and AND functions

    Hi all, Using Excel 2007 I have Googled and Googled and tried to use various examples to help me with this but to no avail. I know nesting isn't ideal, but I need to possibly nest around 10 statements. However I have hit the limit of 7 and can no longer add any more conditions. Below is an...
  8. K

    If isblank today()

    Greetings to Tech Gurus, I'm seeking help in nesting a formula but ending up with an error. Please see below details for my formula nesting. C3= % (this cell will have number up to 100 in %) F3= Date (this cell will have date in MM/DD/YYYY format) G3= formula (below is the formula which i'm...
  9. F

    The specified formula cannot be entered because it uses more levels of nesting than allowed in the current file format

    =IF(E7="Bostan,MA",IF(M7<100,"8.84","5.84")*M7-P7,IF(E7="Delhi",IF(M7<45,"6.55",IF(M7<500,"1.50","0.30")*M7-P7),IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Budapest",IF(M7<100,"4.90","3.18")*M7-P7,IF(E7="Oradea",IF(M7<100,"5.29",IF(M7<250,"4.56",IF(M7<1000,"4.31","0.30")*M7-P7,IF(E7="G...
  10. S

    Nesting ifs combining with and, or, multiple conditions, results

    Hello Excel Gurus, I have been redoing my companies time sheet to make it easier to fill in but I got stuck at this. The left and right sections represent two different sheets. What I'm trying to do is: If Tuesday's job number is the same as Monday's put the hours in the same row. If not put it...
  11. J

    IF, OR, AND formulas using dates?

    Hello all! I am trying to set up a formula for the purpose of alerting me when a client's reminder email should be sent (14 days after acceptance), and when they are past their payment deadline (21 days after acceptance). To do this, I was trying to reference their acceptance email sent date...
  12. I

    The specified formula can not be entered because it uses more than 64 levels of nesting.

    Dears Group Members, I have very long excel (IF) Formula with 292 criteria, a message appear tells me that: (" The specified formula can not be entered because it uses more than 64 levels of nesting"). I ask for your prompt advice/reply in order to overcome the above mentioned error...
  13. P

    New to =IF and ran into a problem

    Hello, I am new to Excel and have to tackle a problem out of my league. Any help would be appreciated... I spent the day (8 hours to be exact - lol) writing out my =if(and( formulas only to receive this message: The specified formula cannot be entered because it uses more than 64 levels of...
  14. A

    Ongoing form w/ TODAY() function

    I am creating documents that are ongoing data entry throughout the month but I want to be able to insert a TODAY() function based on text input into a certain cell (simply, once someone starts typing, that day's date gets input in the date column). So far so good, my IF function for inserting...
  15. C

    Conditional Weighted Average with Multiple Variables

    Hey guys, Spent about 5 hours or more trying to figure this out.. I don't see myself completing the formula without help. I need the weighted average for [(P) Storeys] where the following criteria are met: 1: [(C) Approved] = "Pending" 2: [(O) Approved] = "Pending" 3: [(O) Approved]...
  16. S

    Substitute Nesting Limit Reached (Nested 64 Substitute Formulas)

    Hi, I've been trying to find an alternative to the substitute function where im not limited to the 64 limit nesting rule. At the moment my current forumla has hit the cap. I've tried using vlookup with a table but it doesn't give me the same desired result. What the forumla does is this, in one...
  17. B

    VLOOKUP for partial value search and multi worksheets.

    Im close but still not quite there. This is what I have so far. =VLOOKUP(A2003&"*",Lists!B4:J68,1,FALSE) I have sheet 1 that I enter a code and sheet 2 (Lists) that has all the corresponding codes to customer data. The problem is that I want to look through several column's in sheet 2 with...
  18. B

    Nesting limit reached. How to exceed past 64 nesting IF formula's.

    Hi, I am creating a database for my office that auto fills most of the information when entering a particular code that corresponds to a customer. IE the first 4 digits in a cell entry would be the customer code and the other 4 would be the job reference (1465-0045). A separate cell with multi...
  19. P

    Freight Estimator for how many skids can fit on a flatbed

    Hello, I would like to build a calculator for how many skids (of different sizes) would fit on a 38' Long x 8'Wide Flatbed truck, a 12' Long x 8' Wide Flatbed Truck and a 48' Long x 8' wide truck. Is there any way to input multiple skid sizes and configure which truck those skids would be best...
  20. A

    13 Nested IF statements not returning "False" when relevant values should return "a"

    =IF($I15=1, IF(OR(VLOOKUP(J$5,$A$5:$E$68,2,FALSE)=$J$4,VLOOKUP(J$5,$A$5:$E$68,3,0)=$J$4,VLOOKUP(J$5,$A$5:$E$68,4,FALSE)=$J$4),"a",""), IF($I15=2,IF(AND(VLOOKUP(J$5,$A$5:$E$68,5,FALSE)="Y",(VLOOKUP(J$5,$A$5:$E$68,2,FALSE)=$J$4)),"a"...

Some videos you may like

This Week's Hot Topics

Top