EXP function for squared value

[pban92]

I’m trying to use EXP function of a squared value. Can’t seem to figure out what I’m doing wrong. The answer should be 0.67 but getting 1.48. Thanks in advance.

 

[Peter_SSs]

The answer should be 0.67 but getting 1.48.

What is the formula that you are currently using and what value(s) is in the cell(s) that the formula refers to?

Consider using XL2BB for answering my questions.

 

[pban92]

What is the formula that you are currently using and what value(s) is in the cell(s) that the formula refers to?

Consider using XL2BB for answering my questions.

Sorry I thought the image was attached. Here it is.

 

[Peter_SSs]

To follow the syntax shown in I1, you need:

=EXP(-((5000/8000)^2))

 

[pban92]

Thanks "minus" should be given separate treatment!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.