Or

[VBisgreat]

Hi all,

I have two col of data, col A and col B. I want to write a formula so that if col A is blank or col B is blank then col C is blank, if not then col C=A*B.

Thank you,

VBisgreat!

[Colin Legg]

Hi,

Here are a couple of options:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1)),A1*B1,"")


=IF(COUNT(A1:B1)=2,A1*B1,"")

[NBVC]

VBisgreat,

Next time please be a bit more creative with your thread title.

Thanks.

[royUK]

And also where you post the question. This doesn't appear to be a programming question