View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smoore
 
Posts: n/a
Default Force function to show positive or negative number?

Looks, like we've gotten there now. What I finaly found to work stems
from your last suggestion.

=IF(ISERROR(D2/2,2)),"",ROUND(D2/2,2))

This leaves me a clean worksheet if there are no figures in D2 where
before if D2 was still empty I had #value errors. This works perfectly.
Thank you very much for your help.

Scotty