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?

When you format a cell as currency you get a custom format like this
(depending on the otpions you chose)...
$#,##0.00;[Red]$#,##0.00
Choose the type of currency format you want, and then click on custom. You
should see the format like the one above.
if you want 0 values to be hidden, all you have to do is add a semicolon on
the end, like this
$#,##0.00;[Red]$#,##0.00;

"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?

ToolsOptionsView, uncheck Zero values

--
Kind regards,

Niek Otten

"Mamarita" wrote in message
...
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?

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

On Thu, 09 Feb 2006 18:30:01 +0100, Niek Otten wrote:

ToolsOptionsView, uncheck Zero values
You might like to try:

=IF(C60,C12," ")


This simply says that if the value in, say the quantity cell (say c6) is
non-zero then display the value (e.g. C12) otherwise display nothing