Create a new Excel spreadsheet. Fill out three rows as follows:<br><br>A1, A2: Foo, 0.5<br>B1, B2: Bar, =B3-B1<br>C1, C2: Total, 100.0<br><br>You should (obviously) get 0.5 and 99.5 in the B column.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results