IF AND ISBLANK

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Louise - 07 Feb 2008 19:06 GMT

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

Reply to this Message

Conan Kelly - 07 Feb 2008 20:03 GMT

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

> I'm using 2007.
> The Worksheet as 6000 line and subtotal of 2000. The subtotal is base on
[quoted text clipped - 16 lines]
>
> Thank you

Reply to this Message