Hi,

if A1 and A2 contain formulas, testing with ISBLANK() will only work if the formula returns a blank or empty string (""). If the formula returns a number, and the number is zero, ISBLANK() will not work, so you need to change the condition in your IF statement. Something like

=IF(A2=0,A1,A2)

should work

cheers

Teylyn