cell shows value because the formula is not been complete

**palmer19** · 06-13-2010, 05:41 AM

ive got a setup where a you pick a item in cells A and in cells B it shows the price they then type the quantity of the item in cell C. And in Cell D i Have e.g. B1*C2 and its shows Value When no item selected but because of the way i need it to work is there some formatting etc that i can use to get it to put "£0" if no item is selected

thanks for your time

Josh

**royUK** · 06-13-2010, 05:58 AM

Try
=IF(ISBLANK(D5),0,D5)

**palmer19** · 06-13-2010, 06:24 AM

Hi that doesnt seem to work if you look at the attactment it shows what i mean in the sheet labbelled main meals. at the unit price it shows value in some of the cells and i really need it to say £0.00 as the sum to add all those value at the bottom in total says VALUE due to the others

thanks

**royUK** · 06-13-2010, 06:40 AM

It does work, you simply need to understand the examples offered & apply them. Don't expect us to do it for you,you won't learn that way

=IF(ISBLANK(C9),0,C9*D9)

You should also remove the empty row below the headers in your data table. There should be no empty rows or columns within a tableof data.