Hiding zero formula results

M

Millan

I have a form with table in which I have formulas calculating the total price
by multiplicating quantity of item and its price and at the end at bottom
line I use formula SUM(ABOVE). The formulas still show the result zero (0) in
every line even if nothing was put into item quantity and item price columns.
Is it possible to hidden this values and to show only the sum different from
zero? I made a several tests with IF command, bu did not succeeded. Many
thanks for any help in advance.
 
G

Greg Maxey

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

What does this question have to do with VBA?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hiding zero results in formulas 3
Data Entry Confusion 1
requiring column entries 1
inventory problem 1
Lookup 0
Computing total sales with a query 2
Subtotals 3
Formula for Invoice 10

Top