Previous post

  • Thread starter Thread starter David Moss
  • Start date Start date
D

David Moss

Maybe I should have clarified that there is a calculation ( =(c18*14)+d14 )
in the cell I am trying to create my auto fill column from, and as I drag it
down, it creates a new & correct calculation for the subsequent rows, (
=(d19*14.......etc), but it doesn't leave the cell blank, but calculates it
as 0.
 
Try using something like:

=IF((C18*14)+D14=0,"",(C18*14)+D14)

Alter as needed...

MRO
 
Back
Top