Ravi Sir's Cards › Excel
Expense Reimbursement System in Excel (card 1 of 2)
Revision card 1 for Expense Reimbursement System in Excel: Claim number: ="EX-"&TEXT(ROW()-4,"000") gives EX-001; Travel amount by km: =G5*IF(E5="Car travel",Setup!$B$4,Setup!$B$5) gives ₹1,620; Payable: =IF(AND(L5="Approved",K5="OK"),J5,0) gives ₹1,620.
Read card text
What this card says
1 for Expense Reimbursement System in Excel: Claim number: ="EX-"&TEXT(ROW()-4,"000") gives EX-001
Travel amount by km: =G5*IF(E5="Car travel",Setup!$B$4,Setup!$B$5) gives ₹1,620
Payable: =IF(AND(L5="Approved",K5="OK"),J5,0) gives ₹1,620.
Learn this in the lesson: Expense Reimbursement System in Excel: Claims, Km Rates, Category Limits, Bill Check, Approval and Payment Status