Hello all... I've received great tips here in the past, so I'm back for more.

I'm trying to acheive the following... if, for example, cell A1 is a number, I wan't my resulting cell (let's call it B1)to show that number. If cell A1 is blank, I want B1 to show data that is linked to another cell, C1, . I've acomplished this using the following formula in cell B1:

=IF(ISNUMBER(A1),A1,C1)

MY PROBLEM is that I need to expand on this so that if cell C1 is blank, I want B1 to return a blank cell, rather than "zero" the way it is now.

Thanks for any help!

Jason