Hi all, im having trouble with my assignment, and wondering if anyone here could help me out..Heres the assignment question-

"If OCCUPANCY is grater than 71% it is considered to be high. In the RESERVATION section use a function to calculate whether the OCCUPANCY for MON is high. If the BOOKINGS for MON are grater than the result of the named cell ROOMS (B8) multiplied by 71% then HIGH should be displayed in the cell, otherwise it should be left empty. Replicate this formula for the other cells"

I think i need an "IF" statment. But i dont know how to create the formula- Heres a screenshot-

\1

Can someone please help me out?
Thanks
Owen