Question: Enter an IF function in cell A 2 that will alert the user if data has been added to the worksheet that exceeds the cell

Enter an IF function in cell A2 that will alert the user if data has been added to the worksheet that exceeds the cell capacity in the SUM functions in the range G2:I2. Use the ISBLANK function in the logical_test argument of the IF function. The ISBLANK function should determine if cell A41 is blank. If the output of the ISBLANK is true, then the output of the IF function should be a blank cell. If the output of the ISBLANK function is false, the output of the function should be: Report totals are missing data!

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