Ravi Sir's Cards › Excel
Pocket Money Tracker in Excel (card 1 of 2)
Revision card 1 for Pocket Money Tracker in Excel: First balance: opening + or − the first amount: =$B$3+IF(C6="In",E6,-E6) gives ₹350; Running balance: =F6+IF(C7="In",E7,-E7) gives ₹310. Includes an example data table.
Read card text
What this card says
1 for Pocket Money Tracker in Excel: First balance: opening + or − the first amount: =$B$3+IF(C6="In",E6,-E6) gives ₹350
Running balance: =F6+IF(C7="In",E7,-E7) gives ₹310. Includes an
Example
data table
Learn this in the lesson: Pocket Money Tracker in Excel for Kids: Running Balance, Spending and a Savings Goal