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