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 G3 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 G4:G11.
In cell H3, 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 H3:H11.
Edit cell G3 by enclosing the formula as the Value argument in an IFERROR function. Type No April $ in the Value_if_error argument.
Edit cell H3 by enclosing the formula as the value argument in an IFERROR function. Type No May $ in the Value_if_error argument.
Copy the functions from the range G33H3 to the range G4:H11.
 functions. In cell G3 on the Summary sheet, enter a formula

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 Databases Questions!