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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Concatenate with line breaks but ignore blank cells 3
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
IF and ISBLANK Functions 1
if(and(isblank( formula help 2
RUNNING TOTAL 7
IF and ISBLANK functions 2
IF and ISBLANK functions 1
IF and ISBLANK 4

Top