I'm attempting to write a formula to calculate the number of positions gained/lost on a cell.

For example:

If `A1`

has a positive value (example 52.13), then subtract `C1`

from `B1`

.

If `A1`

has a negative value (example -36.12), then subtract `D1`

from `B1`

.

This is the formula I have been playing with:

`=IF(AND(S9>=0,N9-L9)*OR(S9<=0,M9-L9)`

Any help would be great !