Assignment Help?

O

owensmorgan

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

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

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

[image: http://img.photobucket.com/albums/v312/owensmorgan/help1.jpg]
http://img.photobucket.com/albums/v312/owensmorgan/help1.jpg

Can someone please help me out?
Thanks
Owen :confused
 
E

Earl Kiosterud

Owen,

=IF(F12 > ROOMS*71%, "HIGH", "")

This is untested. Actually, putting a hard number, like the 71%, into a
formula is considered bad practice, but at this point it's probably OK.

To replicate down the column, use Copy/Paste, or the Fill Handle.

You have to post back with a description of how this works before we'll help
you with other stuff. That way you're learning, and we know you're not just
getting us to do your assignments! :)

Hope this helps.

Earl Kiosterud
www.smokeylake.com


"owensmorgan" <[email protected]>
wrote in message
news:eek:[email protected]...
 
O

owensmorgan

Hi, thanks for the help. I understatnd how it *should* work. But i don
understand how to enter the formula, this is what i think-

If the number in the "Bookings" column is grater than 71% of number i
the "Rooms" cell. Then it will show as "High" in the Occupancy column
If it is less, then it should be left blank.

I think i have done it correct now with your help. Thank you.

I will probably need more of your help later on in the assignment. S
for now, thenks alot :D

Owe
 
Top