nesting

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

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

=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"...

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

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

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

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

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!

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

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

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

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"...

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

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

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

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

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

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

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

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