Ravi Sir's Cards › Excel
Event Management System in Excel (card 2 of 2)
Revision card 2 for Event Management System in Excel: Remaining budget: =B5-D5 gives ₹25,000; % of estimate used: =IFERROR(D5/B5,0) gives 83.3%; Cost to plan: estimate or spent, the larger: =MAX(B5,D5) gives ₹1,50,000. Includes an example data table.
Read card text
What this card says
2 for Event Management System in Excel: Remaining budget: =B5-D5 gives ₹25,000
% of estimate used: =IFERROR(D5/B5,0) gives 83.3%
Cost to plan: estimate or spent, the larger: =MAX(B5,D5) gives ₹1,50,000. Includes an
Example
data table
Learn this in the lesson: Event Management System in Excel: Budget vs Actual, Vendor Expenses, Task List, Quotation and Profit