Auto filling formulas as needed

[estone4009]

I have a sheet set up witht he correct formulas and I want the way it is now if I use auto fill I get a bunch of divide by zero errors. The user will enter a new new line of data every week and doesn't need to see pages and pages of Divide by zero errors. Is there a way to have it autofill the formula when that line is used or is there a way to hide the divide by zero errors and not show up in printing.

 

[KenWright]

You can fix the formulas so that they check for a value that doesn't equal 0 in what would be the denominator and simply have it return a 0 or a blank if that is the case eg

=IF(A1=0,"",A2/A1)


Another option would be to use Data / Form for them to enter their data and this will then enter the formulas for you.

Regards
Ken............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------