RobJanine
asked on
SIMPLE EXCEL QUESTION RELATING TO DELETEING ROWS.
I am new to excel 2010, I am sure this didnt used to happen in excel 2003 but here is the problem:
I have a formula in say E10 that looks in cell E10 and E11. this works fine.
But if I delete row 11 the formula in E10 does not work anymore. seems to be putting #REF! in the formula in E10 where it references E11.
I want to be able to delete rows but other formulas referencing this row would still work. Row 12 would now be row 11 if 11 deleted.
Cheers
Rob
I have a formula in say E10 that looks in cell E10 and E11. this works fine.
But if I delete row 11 the formula in E10 does not work anymore. seems to be putting #REF! in the formula in E10 where it references E11.
I want to be able to delete rows but other formulas referencing this row would still work. Row 12 would now be row 11 if 11 deleted.
Cheers
Rob
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks alot Kevin, thanks for explaing the problem clearly too.
Cheers
Rob
Cheers
Rob
ASKER
=(IF($B10=B11, (IF($E10=E11,"IN","OUT")),
if i delete row 11 this is what the formula now reads:
=(IF(B10=#REF!, (IF(E10=#REF!,"IN","OUT"))
Cheers