IF AND ISBLANK

L

Louise

I'm using 2007.
The Worksheet as 6000 line and subtotal of 2000. The subtotal is base on the
product number (C column) and I would like to have not only the product
number (C column) on the sub-total line but also the description (D column)

A an example I want cell D3 (which is blank) to repeat the description text
in D2

So I'm using the formula

=IF(ISBLANK(D3),"(D2)","")

But it does not work. the result is also 0

What am I missing ?

Thank you
 
C

Conan Kelly

Louise,

Remove the quotes and parentheses from D2:

=IF(ISBLANK(D3),"(D2)","")

....should become...

=IF(ISBLANK(D3),D2,"")

Actually, looking closer at that, this cell will be blank when there is
something in D3 and it will have D2's value in it when D3 is blank (if I'm
not mistaken). Don't you want the opposite?

If that is the case, then change my solution above to...

=IF(ISBLANK(D3),"",D2)

HTH,

Conan
 
Top