Hiding zero results in formulas

[Millan]

I have created the form in which I use folmulas calculating price by
multiplicating quantity of ordered items by their unit price. At the bottom
line I use the formula SUM (ABOVE) tu sum up all subtotal prices to a total
one. The problem is, the formulas show result zero even if nothing have been
put into quantity or unit price columns. I tried to apply command IF in order
to display blank space if the result equals to zero, but without any success.
Could you please help me? Many thanks in advance.

 

[Greg Maxey]

Asked and answered.

Since you are asking the same question twice, so will I. What does
this have to do with VBA?

 

[Millan]

Greg, thank you for your help. Sending the question the server replied an
error occured and the question was not send, so that is why I sent it again.
Concernig VBA, I was not sure in which Word topic I shoud put my question
(General?, Tables?) and I am still not.
Sorry for that.
Millan
„Greg Maxey" napísal (napísala):

 

[Greg Maxey]

OK,

Did you get this answer:

Use a construction like:
{ =Sum(above) \# "0.00;(0.00);" }