What's wrong with this simple nested formula?

[philia]

I'm basically trying to say if a cell (E2) reads "positive" or "negative", then apply this equation. What am I doing wrong? Here it is:

=IF(E2="positive"),=(D2-F2/G2-D2), IF(E2="negative",=(F2-D2/G2-D2)))

Thank you.

 

[crook_101]

Hi,

If E2 can only be either positive or negative with no blanks, the following should work

=IF(E2="positive",(D2-F2)/(G2-D2),(F2-D2)/(G2-D2))

Regards,
Ian

 

[Jonmo1]

Judging by the only difference between the True and False formula is you switch D2-F2 to F2-D2.
I would guess you have a formula in E2 that tells you weather one of them is negative or positive...right...

Try this instead of all that..

=ABS(D2-F2)/(G2-D2)


Hope that helps.

 

[philia]

Sorry, I think I wasn't clear. The cell itself will either have the word "positive" or the word "negative" in it.

Hi,

If E2 can only be either positive or negative with no blanks, the following should work

=IF(E2="positive",(D2-F2)/(G2-D2),(F2-D2)/(G2-D2))

Regards,
Ian

 

[crook_101]

No worries, pleased you are sorted

 

[philia]

I made a slight modification of the formula and it worked, so many thanks.

Also thanks to jonmo1, too.

No worries, pleased you are sorted