owensmorgan
New Member
- Joined
- Nov 7, 2005
- Messages
- 5
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-
http://img.photobucket.com/albums/v312/owensmorgan/help1.jpg
Can someone please help me out?
Thanks
Owen[/img]
"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-
http://img.photobucket.com/albums/v312/owensmorgan/help1.jpg
Can someone please help me out?
Thanks
Owen[/img]