Hiding zero results in formulas

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Millan - 16 Oct 2006 13:18 GMT

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.

Reply to this Message

Greg Maxey - 16 Oct 2006 13:24 GMT

Asked and answered.

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

> 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
[quoted text clipped - 3 lines]
> to display blank space if the result equals to zero, but without any success.
> Could you please help me? Many thanks in advance.

Reply to this Message

Millan - 16 Oct 2006 13:47 GMT

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):

> Asked and answered.
>
[quoted text clipped - 8 lines]
> > to display blank space if the result equals to zero, but without any success.
> > Could you please help me? Many thanks in advance.

Reply to this Message

Greg Maxey - 16 Oct 2006 14:17 GMT

OK,

Did you get this answer:

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

> 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.
[quoted text clipped - 16 lines]
> > > to display blank space if the result equals to zero, but without any success.
> > > Could you please help me? Many thanks in advance.

Reply to this Message

Rate this thread: