ExcelBanter - If certain cells not blank, and cells in range are, set values to

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - If certain cells not blank, and cells in range are, set values to (https://www.excelbanter.com/excel-discussion-misc-queries/177449-if-certain-cells-not-blank-cells-range-set-values.html)

ktoth04

If certain cells not blank, and cells in range are, set values to

Hi, I'm trying to do the following...

On Sheet 1, where x is rows 13:27
If the values in D,F,H,J,and L for row x are NOT BLANK
set the value of the cells (Nx:Tx) that are blank to zero

Any help, or advice about how to implement any of this is appreciated....
Thanks!

All times are GMT +1. The time now is 11:14 AM.