Question: On your own, use IF function to create a formula that will classify the data into the following groups based on TotalProductCost. table [

On your own, use IF function to create a formula that will classify the data into the following groups based on TotalProductCost.
\table[[Total Product Cost,Classifications],[0-100,MARGINAL],[100-500,LOW],[501-1000,MEDIUM],[1000+,HIGH]]
Date Functions
These functions are useful to extract data that is in a date column. The syntax is as follows:
= Day (TableName [ColumName])
= Month (TableName [ColumName], MM - mmmm) larr refers to the format of the result
= Year (TableName [ColumName])
15. On your own, use all 3 date functions to extract the day, month, and year from the Date column.
On your own, use IF function to create 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 Programming Questions!