How do I hide zero values but keep currency format in P.O. form?
I'd just check for numbers upfront:
=if(count(c2,e2)<2,"",c2*e2)
But you could hide all the 0's:
tools|options|view tab|uncheck zero values
or you could give those cells a custom format:
Format|cells|number tab|custom category:
General;-General;
Mamarita wrote:
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only if
there is a value in the Quantity and Unit Price section. I formatted the
Total cells to Currency. But if there are no values in Quantity or Unit
Price, zero values appear in the Total cells. How do I format the total cells
to only show price values when there are values in Quantity and Unit Price?
--
Dave Peterson
|