How can I change this formula to enter data from one of two cells

[barman]

Hi,

If a cell in column B has a number I need a formula in column D that enters it there. However if the cell in column B is blank, then I need the number in the cell of same row in column C to be entered in column D.

My current formula is

Please Login or Register  to view this content.

Column A has part names, so if no part name column D stays blank. This formula works great to input any numbers in cells in column B into column D... I just don't know how to change it so if the cell in column B is blank it will look at the same row in the cell in column C and input that number into column D.

Any guidance would be greatly appreciated!

[barman]

Figured it out, or at least this seems to work

Please Login or Register  to view this content.