Jenni,

You're taking the bigger number away from the smaller number instead of the
other way round.

If A>B Then
Result =A-B
Else Result =B-A
End If

HTH
Henry

value as .1  and -.5 subtract -.7 the return value is .2 and i need it to
be -.2

Hi Jenni,

From your description, you are getting the correct results for
ValueA-ValueB=ValueC. What you want requires your formula to be expressed as
ValueB-ValueA=ValueC. If you need to show the same results as +ve values in
some places and as -ve values elsewhere, simply multiply the results by -1
wherever they need to be inverted, eg: (ValueA-ValueB)*-1=ValueC or, if
ValueC is bookmarked, you could use invert the required fields with:
{={ValueC}*-1}

Cheers

value as .1  and -.5 subtract -.7 the return value is .2 and i need it to
be -.2