Thread: How to do formula If a<-.1 and .1, return em dash, otherwise do x
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JVRB JVRB is offline
external usenet poster
  
Posts: 4
Default How to do formula If a<-.1 and .1, return em dash, otherwise do x
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