nesting formula

Been wracking my brains with this one and I suspect there is an easy solution but I cannot figure it out. I'm trying to work out the number of days since a particular item has sold but in some instances, it has never sold and so Excel churns out a reference of 43726. <tbody> REF LAST SOLD...

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

I had excell 2007 and i upgrade to 2016. everything was working fine with 2007 and also excell 365 i have this nesting and how i can change to be able to used with excell 2016 =(IF(G3="STORAGE 1",".666666666",(IF(G3="STORAGE 2",".80",(IF(G3="TRANSPORTATION",".80",(IF(G3="STORAGE...

Hi, I an trying to solve this nesting but cant. Below is the formula that tried to use but gives me the error for too much nests. Below the formula is the table with the values. I tried a VLOOKUp but didnt work, probably I was doing it wrong...

Hello- I was using a formula that summed 2 cells on a bank account spreadsheet: =F214+H213 F is an amount withdrawn/deposited column H is a running balance of column So my formula takes the previous balance and sums it with the new withdrawal/deposit being entered, giving the new balance Now I...

Hello, I am trying to figure out how sum up two different functions into one cell. I have figured out the initial formula to sum the functions, I am using an array formula with the sum nested, however, I cannot figure out how to get just the one functions answer to populate if the second...

Hey guys, Just need some help with nesting several IF statements to calculate how much time has passed between two dates. I'm working with data that experienced a shift in how fields were being used in the program, so older data is missing the current field and instead utilizes another date...

Hi please help. I have the below formula but it has too many nesting levels: =IF(C4="1st",'Step 1 Materiailty Assessment'!B25,IF(C4="2nd",'Step 1 Materiailty Assessment'!B26,IF(C4="3rd",'Step 1 Materiailty Assessment'!B27,IF(C4="4th",'Step 1 Materiailty Assessment'!B28,IF(C4="5th",'Step 1...

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

Hello, I am trying to make a dynamic chart that will update when I put 2 columns of information in: Portfolio and Benchmark returns. I have everything worked out except one area, and it has to do with a date. I have maybe 100 different portfolio paired returns, so I made one master worksheet...