How to clear cell's content?

**NZL** · 03-08-2013, 01:53 AM

Hi there,

I am having a smallish problem.
Let's say i have the following situation:
A1 B1 C1 D1 E1
id description price QTY Total

I am using Vlookup to get data for A1,B1,C1.
Obviously until "id" is not entered A1,B1,C1 remain blank. Once it is entered, A1,B1,C1 are filled with relevant data.
For D1 i have got the following formulae =IF(ISBLANK(A1),0,D1) . That is, i want my qty to be equal 0 if no id is entered or be assigned the number that has been entered. Everything works fine. For example if price is 10 and qty is 2 , then total is 20.
However, when i delete data from cell A1 content of D1 (QTY) remains 2 and does not equal 0 .
Moreover, original formulae is permanently cleared from the D1.
I am not sure what's wrong with my formulae

Any help would be much appreciated.

**wfm007** · 03-08-2013, 02:15 AM

if possible attach the reference file

**NZL** · 03-08-2013, 02:54 AM

Originally Posted by wfm007

if possible attach the reference file

Hi,

I am not able to attach the file as i don't see the need.
If you have an idea of how i can clear the cell's content with a simple formulae (similar to what i posted in my original post) it would be great.

Cheers

**aydeegee** · 03-09-2013, 10:04 AM

"Obviously until "id" is not entered" - I am not sure how this works

In your example where does the 2 come from? The formula for D1 "=IF(ISBLANK(A1),0,D1)" reads if A1 is blank then use 0, otherwise use D1" (which it can't)

As WFM007 says send a reference file. A picture is worth a thousand words

Regards

Alastair