Ravi Sir's Cards › Excel
Trip Budget in Excel (card 1 of 2)
Revision card 1 for Trip Budget in Excel: How many share this expense: =COUNTIF(F5:I5,"Y") gives 4; Shahrukh's share of this expense: =IF(F5="Y",$E5/$J5,0) gives ₹800.00. Includes an example data table.
Read card text
What this card says
1 for Trip Budget in Excel: How many share this expense: =COUNTIF(F5:I5,"Y") gives 4
Shahrukh's share of this expense: =IF(F5="Y",$E5/$J5,0) gives ₹800.00. Includes an
Example
data table
Learn this in the lesson: Trip Budget in Excel: Plan vs Actual, Expense Log and Split Costs Among Friends (Who Owes Whom)