nesting if statement

I'm trying to take an average of the "Average" column depending on what the month in the "Date" column is. Date Trial 1 Trial 2 Trial 3 Average 1/12/2023 100 101 102 =mean(B2:D2) = 101 1/13/2023 103 104 105 =mean(B3:D3) = 103 2/12/2023 106 107 108 =mean(B4:D4) = 105 I'm trying...

I Need Hyphen " - " Symbol via Formula, Unique Number based Condition , Found Duplicate & set Hyphen Symbol - in D Coloumn

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

I 24 Team members that I have to place into a schedule. I have 182 cells that this has to process thorough. in the schedule I want to place a #1 through 24 in cells and when I do it turns another cell to state TM 1 through TM 24 I ran into a nesting issue when getting past 10 TM here is what...

I'm having trouble nesting loops! How do I nest an "if statement" into a "for to" statement? Can anyone point me to a good place to check my nesting loops? I'm essentially trying to populate a master list of numbers (z,1) by using matching criteria between two other lists. If two cells of...

Hello- Can anyone help me with a nesting statement that I am trying to work into the Data Validation Source and I can't seem to get around the error. I have 5 IF statements in Sheet1 that I am trying work into the Data Validation Source. So my formula should be: =IF($AM$16="South...

So here is what I have that is not working =IF(AND(G5<10),"10"), IF(AND(G5>40),"40") And here is what I want it to do if G5 is < 10 then = 10, if > 40 = 40, if between >10<40, G4*.55 Any help would be AWESOME!

:confused: Hi! Below is my discrepency.. IF cell is <=.09, .09 should be the outcome. IF <NOBR>cell</NOBR> is >.09 but <=.33, .33 should be the outcome. IF cell is >.33 but <=.67, .67 should be the outcome. IF cell is >.67 but <=.99, .09 should be the outcome. If cell is = 0, .09 should be...