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 A 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 G:I Use the ISBLANK function in the logicaltest argument of the IF function. The ISBLANK function should determine if cell A 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
