scm1001

11-13-2008, 11:22 PM

Excel novice here.

I need to have a calculation where not all of the columns have any data in them all the time (depending on how many instance I enter). However some cells have formula that depend on two other cells dividing e.g D2=D4/D5. Is there a way that i can get excel to ignore the 0/0 error that will sometimes arise with empty cells.

thanks

I need to have a calculation where not all of the columns have any data in them all the time (depending on how many instance I enter). However some cells have formula that depend on two other cells dividing e.g D2=D4/D5. Is there a way that i can get excel to ignore the 0/0 error that will sometimes arise with empty cells.

thanks