Sum formula in E5, add in same cell formula for gain/loss?
You might also want to put a TEXT around the C1, so that you can
ensure currency with 2 dp.
Pete
On Jan 21, 11:53*pm, "Vacuum Sealed" wrote:
Thx for the pointer there Pete.
So with
A1 = $OldSalaryValue
B1 = $NewSalryValue
C1 = ValueDiff (=$B$1-$A$1)
D1 = %Diff (=$C$1/$A$1 [%Format])
the resulting formula of
=C1&" ("&TEXT(D1,"0%")&" )"
will give you
-$263.80 (-13%)
HTH
Mick
|