Question: Write an Excel formula or function to calculate the costs of all shots (rabies cost shots (cell Ill and copied down to cell 160) &

Write an Excel formula or function to calculate
Write an Excel formula or function to calculate the costs of all shots (rabies cost shots (cell Ill and copied down to cell 160) & immunization costs (cell Ji1 and copied down to cell J60)) that have been given to each dog while in the shelter. Total these in cell K11 through K60 [called Total cost shots] using an Excel formula or function. Use Accounting format for these cells. Write an Excel formula or function to calculate the food cost (cell Lil and copied down to cell L60 ) and treat cost (cell Mil and copied down to cell M 60) that each dog will eat if applicable. Use Accounting format for these cells. Write an Excel formula or function to total all expenses or costs for each dog (cell N11 through N60 [called total costs]). Round the value to the nearest cent. Use Accounting format for these cells

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!