I have two worksheets, namely HATAK and DEADLOAD.. im formulating my HATAK
worksheet, heres my formula in cell C8
=IF(DEADLOAD!A20="","",DEADLOAD!A20).... my problem is, what if DEADLOAD!A20
is blank and A21(A21 instead of A20) has a value, and I want the result to be
on cell C8.. and if A21 is followed with a value at A22, I want the result to
be on cell C9.. Hope you get what I mean... thanks....