1. 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...
  2. 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"...
  3. J

    Creating Formula to Match Old Account Structure with New Account Structure

    Hey all, I'm attempting to create a formula that will automatically search and paste the new account structure with the old. In short, the "location" in the new structure is different from the "location" in the old structure. The new location is determined by the old location account number...
  4. U

    Nesting Multiple Date and Time Functions

    Hello Excelians, I have to calculate a 24hr SLA between date/ time Received in the following format of 0/0/00 0:00:00AM and date time Sent in the same format. ( Column A Received and Column B Sent) and Column D will display the time in between in the 37:00 hr format. A simple subtraction...
  5. C

    nesting lower case function

    excel 2013, Win 7 I need to create twitter accounts for my company but cannot finalize my formula. My formula is: ="@"&LEFT([Lastname],3)&LEFT([@Firstname],1)&"CG" which is giving me @BerCCG. This example is for Carla Bere..."Ber"-being the 3 first letters of last name "C"-initial of first name...
  6. K

    Nesting IF and DATEDIF

    I have a spreadsheet with the following cells. Cell B23= Purchase Date Cell $E$7 = Today's date Cell F23 = Purchase Price Cell F24 formula needed as described below I need to write a formula that compares the two dates and does the following. If the Purchase date B23 is after Today's date...
  7. J

    "=IF" with more than 64 levels of nesting?

    I am using excel to make sheet with drop list where the price of the corresponding item appears in a specified cell. However there's more than 64 items and i can't add more "IF". Here's the formula: How could i could i extend the list? Thank you in advance!
  8. LostInTheTrees

    Pivot Table Challenge

    Hello! I've just truly begun exploring the power of Excel Pivot Tables, and I have run into a dilemma that I cannot seem to find an answer to. As a result, I'd love a little insight from those of you with a greater understanding. I have 2 pivot tables built off the same data. In order to...
  9. S

    Too many variables for nesting "IF" function

    I have a rather large spreadsheet that gives me the following information: 10112 Biloxi MT Manager Trainee BOP Active 2 CSR Customer Service Rep BOP Active 2 MGR Manager BOP Active 1 10112 Biloxi BOP Active 5 This...
  10. N

    IF / MEDIAN Nesting Function Help

    Hello world: So I am building a spreadsheet that has multple rows of data and criteria. The objective is to have a value of F3 (given criteria in column B) minus the median of values of column F (given the same criteria of column B). I am trying the code apply to the entirity of column F. My...
  11. S

    Problem with nested statements.

    Hello, I wonder if some one can help me solve the folowing... I keep getting this error message "The specified formula connot be entered because it uses more levels of nesting than are allowed"...
  12. B

    Nesting Various Ranges Within an IF(COUNTIF( formula

    I'm trying to come up with a formula that will return "4" if the value of Q50 can be found in a certain range. What that range is, however, will vary depending on only one condition. So, I have the following: =IF(COUNTIF("RANGE",Q50),4,0) where I want the "RANGE" to be: N2:N33 if B69=1...
  13. D

    Vlookup with Conditions

    Hi, I'm hoping for some help writing a formula. I have a pivot table which is an extract of accounting data. I need to move the data from the pivot table to a template used in a monthly report. Essentially, my pivot table is Cost centre numbers as the Column labels, and General Ledger numbers...
  14. F

    help with nesting "IF" functions

    Hello I am trying to use the if function but I am having so trouble coming up with the correct answers. Here is a little background: A company has the following compensation for its sales department: A 5% commission on the actual selling price for cars sold at 98% or more of the asking...
  15. S

    Trouble Nesting a formulae

    Hi Guys, Wondering if you can help me... I'll try my best to explain it. I am trying to write: If one number (1) equals another number (1) then do a vlookup. I can do that fine and if it doesn't equal the number it returns False, so I know that is right. What I want to do is carry...
  16. J

    How Do You Show Multiple Variables (columns) In Pivot Table Without Nesting?

    I'm a newbie to the form, so thank you in advance for your responses! I've used spreadsheets for a long time (remember wth spreadsheets were done in VisiCalc?), but am perplexed by a seemingly routine matter. I would like to create a pivot table that summarizes my variables and shows each...
  17. J

    Nesting IF Functions

    I'm trying to solve the following problem and am getting close but I'm not quite there. Any insight would be much appreciated. What I'd like the function to do: if j77 equals "Yes" AND there is text in j74 AND text in J75, return "AM/PM" if j77 equals "Yes" AND there is text in j74 but none...
  18. H

    Multiple IF functions with Formulas within one cell.

    Example:<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> <TABLE style="WIDTH: 426pt; BORDER-COLLAPSE: collapse; mso-padding-alt: 0in 0in 0in 0in" class=MsoNormalTable border=0 cellSpacing=0 cellPadding=0 width=568 u1:str><COLGROUP><COL...
  19. D

    How to Nest 5 Nested IF(AND functions?

    Good Morning Ladies and Gents (Using Excel 2003 (XP)) I've been using the board for the past 3 weeks and i'm pleased to say i haven't had to ask, alas it wasn't to last. am unable to install the add in to post the spreadsheet, so will type it out instead: A B C 1...
  20. J

    Pivot Table Grouping / Nesting Question

    I am having an issue with getting a Pivot Table to display data how I would like to report on it. The column labels are fine, and when I put one field into the row label section, I see data how I would like to. When I add another field to the Row Label section, it nests this within the first...

Some videos you may like

This Week's Hot Topics