Ravi Sir's Cards › Excel
Customer Credit in Excel (card 2 of 2)
Revision card 2 for Customer Credit in Excel: Balance: =I7-J7 gives ₹980; Paid back: =SUMIFS($D$7:$D$19,$B$7:$B$19,H7,$C$7:$C$19,"Payment") gives ₹1,200; Status: =IF(K7>=$B$4,"Remind now",IF(K7>0,"Pending","Clear")) gives Pending.
Read card text
What this card says
2 for Customer Credit in Excel: Balance: =I7-J7 gives ₹980
Paid back: =SUMIFS($D$7:$D$19,$B$7:$B$19,H7,$C$7:$C$19,"Payment") gives ₹1,200
Status: =IF(K7>=$B$4,"Remind now",IF(K7>0,"Pending","Clear")) gives Pending.
Learn this in the lesson: Customer Credit (Khata) Book in Excel: Udhaar Balance per Customer with SUMIFS