View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default Worksheet Calculate

For a cell that contains a percentage, try the following format:

#,##0.00%;-#,##0.00%;;@

If the value is either positive or negative, it will display. If the value
is 0.00%, then it will not display. This is the style that I use in my
workbooks when I want to hide values or formulas that are (or evaluate to)
exactly 0 (zero).

For a formula that returns a value (not a string), like the following:

K29: =IF(H270,R27+C12*R29+C11,0)

then make the IF statement give a value of 0, if the IF condition is FALSE.
Then format the cell as above with a blank part for the negative
specification to cause the 0 value to not be shown.

(I changed the commas in your example formula to "+" signs. I still don't
understand what your formula is doing!)
--
Regards,
Bill Renaud