View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Displaying result in parentheses

Thanks in advance for any help with this...

How do I display the result of a "countif" formula in parentheses? What
would I add to the following formula:

=countif(a:1:a100,"Blue")

so that the result is (35) instead of 35 ?

Thanks!