=if(((isnumber(h41))c41=h41,if(((isblank(h41)),c41=d41,""))

[kylefoley76]

this is a formula that will run down column c

=if(((isnumber(h41))c41=h41,if(((isblank(h41)),c41=d41,""))

if h41 isblank then the number in d41 fills c41, if the h41 has a number in it then that number should fill column c

 

[VoG]

Try

=IF(OR(ISNUMBER(H41),ISBLANK(H41)),D41,"")

This will return 0 if H41 is blank.

 

[Aladin Akyurek]

this is a formula that will run down column c

=if(((isnumber(h41))c41=h41,if(((isblank(h41)),c41=d41,""))

if h41 isblank then the number in d41 fills c41, if the h41 has a number in it then that number should fill column c

C41:

Either...

=IF(H41="",D41,H41)

Or...

=IF(ISNUMBER(H41),H41,D41)

 

[kylefoley76]

aladin,

thanks your code is working.

vog,

sorry, that suggestion of yours didn't work out