i have data in a1:a31 and in a45 i am putting =a1. i then click the black
box at the bottom of a45 and drag until each successive cell contains the
information from a1:a31. some of the cells in the range a1:a31 are empty,
and when i copy the cells from a45:75, those corresponding cells have a 0 in
them. what IF statement do i need to add to a45 that keeps the same
formatting (?) or keeps the blank cell instead of adding the 0?

thanks!