A formula problem.

P

parabola

Hi all Im new to the forum. I have 2 questions re excel 97. I hav
created a spread sheet for a friends lawncare business. It has
columns. The first one is a description of the service. The second on
is the quantity of service. The third one is the unit price. And th
fourth one is the total price. I have it set up so that the fourt
column multiplies the coulmn with the quantity. It works fine excep
that it prints a $0.00 in the total column if there is nothing in th
quintity column. Is there a formula that would allow me to make it s
if there is no number in the quantity column , it would just leave tha
space in the total column blank?

2nd question. Is there a way to lock certain spaces with formulas i
them so that they cannot be erased. I tried right clicling the box an
locking it but it did not work.

Any Ideas or solutions would be greatly appreciated!
Thanks in advance for your help
 
M

Myrna Larson

Assuming quantity in B2, in D2 put the formula =IF(ISBLANK(B2),"",B2*C2)

As for locking, look up Protection in Help. You must set the locking/unlocking
appropriately, then Protect the worksheet.
 
Top