Question: functions. In cell G 3 on the Summary sheet, enter a formula to subtract the April rent from the May rent, and then divide that
functions.
In cell G on the Summary sheet, enter a formula to subtract the April rent from the May rent, and then divide that result by the April rent. Copy the formula to the range G:G
In cell enter a formula to subtract the May rent from the June rent, and then divide that result by the May rent. Copy the formula to the range :
Edit cell G by enclosing the formula as the Value argument in an IFERROR function. Type No April $ in the Valueiferror argument.
Edit cell by enclosing the formula as the value argument in an IFERROR function. Type No May $ in the Valueiferror argument.
Copy the functions from the range to the range :
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
