View some records to ensure that the formula is working propeny.

Syntox: $=$IF$($condition$,$ cell entry if condition is True, cell entry if condition is False$)$

Action $3$: Nested IF $(2$ marks$)$

In the same Sort and IFs spreadsheet, type Bedrooms in cell N$1.$ Colour that new column heading in light green and bold it$.$

In cell N$2,$ create a Nested IF statement to determine if there are a lot of beds in a listed house in terms of bedrooms. If beds is less than or equal to $2,$ then display Small; else if beds is less than or equal to $4,$ then display Medium; otherwise, display Large.

Drag the formula down to apply to all of the records in the dataset for the Bedrooms column.

View some records to ensure that the formula is working properly.

Syntax: $=$IF$($condition$1,$ True, IF$($condition$2,$ True, IF$($conditionN$,$ True, False$)))$c