Previous post

[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.

 

[Rafael Ortiz]

Try using something like:

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

Alter as needed...

MRO

 

[Jen Hearns]

Try this David:

( =(c18*14)+d14,"" )

 

[Jen Hearns]

Try this David:

( =(c18*14)+d14,"" )