Award-winning PDF software
Video instructions and help with filling out and completing Fill Form 2220 Ii

Instructions and Help about Fill Form 2220 Ii
Sarnax Alfred mr. Excel podcast episode 21 99 problem with two auto song hey welcome back to the mr. excel NetCast I'm Bill Gellin couple weeks ago was down in Atlanta Georgia for the Gulf South Council meaning of the IMA a lot of great questions came up in that one including this one that stumped me someone said that they had two columns of a lot of a son so these two cells here press the autosum button and that as they were working they would insert rows insert rows insert rows and then suddenly column two would quit working now that was bizarre like why would that ever happen but then you know as as I was talking through it you know I started to replicate what was going on so we come here we do alt ir to insert a row type the next item and 100 that 800 change this is 900 that's perfect 200 1600 changes to 1800 that's perfect alright but then insert another row and this one has a value beautiful the thousand changes but column two for whatever reason has no value at all and then we insert a new row alright see and that's where the problem comes in now column 1 is going to work I want to enter 123 and the number changes but over here because I didn't type anything for jicama in c11 when I type the value here - 2 - BAM it's not working right so what we're what we're running into there is Excel is extending that formula if you have three or more cells that the formula is referring to Indian sort of 4th cell they'll extend it but the only extended if you had a number and well we didn't add a...