G

#### Guest

..1, Excel will return an em dash, otherwise (ROUND(E12/E10*100,1)

You are using an out of date browser. It may not display this or other websites correctly.

You should upgrade or use an alternative browser.

You should upgrade or use an alternative browser.

G

..1, Excel will return an em dash, otherwise (ROUND(E12/E10*100,1)

G

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

G

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

It does not return an em dash. It appears to ignore the and array and go to

the rounding formula. Do I need to use brackets around the And statement?

G

What are the values in N24 and C10 which do not return the em dash?

Dave

Dave

G

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

G

Get rid of the parentheses aroung the negative 1 and just put -1 there.

Recalculate.

Dave

G

Dave F said:

Get rid of the parentheses aroung the negative 1 and just put -1 there.

Recalculate.

Dave

G

My guess is that it is good practice to use the negative sign to denote

negative numbers in formulas, as opposed to using parentheses.

Dave