{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

INFS 3250 - Assignment 7

INFS 3250 - Assignment 7 - nest AND For Logical1 use...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
INFS 3250 – Assignment 7 Use order of precedence. Determine ages. Nest AND and IF functions. On the customer birthday list, you need to indicate whether a customer is between 1 and 4 years old, between 5 and 10 years old or over 10. The formula uses AND functions nested in IF functions. 1. Open CustAge and save the workbook as [your initials] Assign7 . 2. In cell E3, key Cateory and copy the format from one of the other labels in this row. 3. Determine the customer’s age in column D. Format the results as Number with two decimals. 4. In cell E4, start an IF function. For the Logical_test , nest AND . In the Logical1 box, click cell D4 and key >=5 . For the Logical2 entry, set D4<=10 . This AND function tests if a customer is between 5 and 10 years old. 5. Return to the IF function. For Value_if_true , key Between 5 and 10 . If the results of the AND function are true, this statement will be shown. 6. For Value_if_false , nest another IF function. For the Logical_test
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: , nest AND . For Logical1 , use D4>=1 . For Logical2 , use D4<5 . This tests if the customer is between 1 and 4 years old. 7. Return to the second IF function and key Between 1 and 4 as the Value_if_true . For the Value_if_false , key Over 10 . Click OK . 8. Format the results to match other labels in the row, and copy the formula. Set a horizontal left indent of 1 for the results. 9. Center the labels in rows 1:2 across the data. Use borders, fill, row height and column width to enhance the readability of your worksheet. 10.Change the birthday for Maureen Weinberg to one that will make her over 10 years old. 11.Add a header using a 9-point font in all sections. Make sure the sheet will fit on a portrait page. 12. Make a copy of the worksheet and name it CustBirthdaysFormulas . Hide column C and display the formulas. Fit this sheet to one landscape page. 13.Prepare and submit your work. Save and close the workbook....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online