View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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