Assignment Help?

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

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" <owensmorgan.1y5k0a_1131410100.8148@excelforum-nospam.com>
wrote in message
news:owensmorgan.1y5k0a_1131410100.8148@excelforum-nospam.com...
>
> 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-
>
> [image: http://img.photobucket.com/albums/v3...gan/help1.jpg]
> http://img.photobucket.com/albums/v3...rgan/help1.jpg
>
> Can someone please help me out?
> Thanks
> Owen
>
>
> --
> owensmorgan
> ------------------------------------------------------------------------
> owensmorgan's Profile:
> http://www.excelforum.com/member.php...o&userid=28636
> View this thread: http://www.excelforum.com/showthread...hreadid=483002
>

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

If the number in the "Bookings" column is grater than 71% of number in 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. So for now, thenks alot :D

Owen