Thread: How to do formula If a<-.1 and .1, return em dash, otherwise do x
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave F Dave F is offline
external usenet poster
  
Posts: 2,574
Default How to do formula If a<-.1 and .1, return em dash, otherwise do x
=IF(AND(E12/E10*100-.1,E12/E10*100<.1),"--",ROUND(E12/E10*100,1))

I'm not sure if an em dash is two hyphens, so if it's not, replace the
characters between the double quotation marks with an em dash.

Dave

--
Brevity is the soul of wit.


"JVRB" wrote:

I need to do a formua where IF E12/E10*100 is greater than (.1) AND less than
.1, Excel will return an em dash, otherwise (ROUND(E12/E10*100,1)
Reply With QuoteReply With Quote