Custom conditional columns

You can complete this exercise either on DataCamp in a browser with in-browser Excel or locally using Microsoft Excel with Copilot on your computer.

The emergency department team now seeks to investigate the impact of patients presenting with a fever on their admission likelihood.

Your task will be to create a new column to identify the status of a fever based on the reported temperature at the time of triage vitals assessment.

_If you lost progress, load the workbook 2_1_custom_conditional_columns.xlsx from the Workbooks folder and launch the _Power Query editor.