Use the table to calculate differetn quantities

**chubbychub** · 10-25-2012, 04:56 AM

hi, i started a spreadsheet yesterday and have gotten alot of help from the people on this forum. Thanks.
in expanding more precise spreadsheet and for learning, i would like to add a quantity in the spreadsheet so that it does differetn quantities.
For example:

In B3, that is a set price for 1 item, and if i enter k3 the quantity so that it multiplies by b3

this is what i have L3: =(k3*b3)
that only works when i have a number entered, how can i write it so that if no quantity is entered, than equals to 1 ?

I will attached my sample.

**benishiryo** · 10-25-2012, 05:15 AM

hi chubbychub. like this?
=IF(K3="",1,K3*B3)

**chubbychub** · 10-25-2012, 07:19 AM

yeah, that works, but how come it gives me a whole bunch of 0 on the bottom (where i have no data currently), can you get rid of the of that?

i am using like this: =IF(K3="","",K3*B3) and in K3 i enter a 1 but i have to enter a number in k3.

I think waht i am asking is ambiguos result since i dont think excel will be able to tell if i have data required or just empty space.