**Use NESTED IF Within an IF function:**

BOOKVALUE

CHEAP: (lf price less than or equal to $ 40 )

MEDIUM: (If price more than 40 and

HIGH: (If price more than 80 and

EXPENSIVE: (if price above $120)

* PLEASE SHOW THE WHOLE FUNCTION*

ANSWER WILL LOOK LIKE EXPENSIVE HIGH EXPENSIVE EXPENSIVE HIGH HIGH HIGH HIGH EXPENSIVE EXPENSIVE HIGH CHEAP EXPENSIVE EXPENSIVE HIGH HIGH HIGH EXPENSIVE HIGH MEDIUM MEDIUM MEDIUM EXPENSIVE MEDIUM EXPENSIVE HIGH MEDIUM HIGH CHEAP MEDIUM MEDIUM MEDIUM