Excel formula help.

Anyone?


Posted from TSR Mobile

Have you tried the formula with actual values rather than cell references?

Have you tried using the Formula > Evaluate Formula function to see how it is calculating the result?

Basically im trying to put this formula in excel:
http://gyazo.com/08889b442d46b9218d96a6b7dff4a644

Which i got as:

=(1/SQRT(2))*((2*EXP(-A2))+(2*EXP(-($T$1-A2))))

However its wrong as when i plot a graph i get something different from what is expected.
Can someone help me out?

btw A2 = radius and T1=the value for D (the $signs are there so it doesn't change when I fill down)

In the formula I see |x| which means absolute value of x

This becomes ABS (x) in Excel.
You haven't done this in your excel formula

So the formula should be?
=(1/SQRT(2))*((2*EXP(ABS(-A2)))+(2*EXP(-(ABS($T$1-A2))))

No it's 2*EXP(-ABS(A2)
The rest looks ok.
If it still doesn't work, you need to check you have the correct values in the formula and the correct cell references including absolute references.
We can't tell you if they are correct.