With the actual formula:

=IF(AND(N24/C10*100<0.1,N24/C10*100(0.1)),"€”",ROUND(N24/C10*100,1))

Where N24 is 1,200 and C10 is 4,791,299, I get .02 on the old mechcanical
adding machine and .02 is definitely between -.1 and.1, so I'm not sure where
the wrinkle is. Excel doesn't show an error in the formula. It just doesn't
return the correct result.

"Dave F" wrote:

=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)