Need Help for my assignment.. :)

[owensmorgan]

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]

 

[Tazguy37]

Welcome to MrExcel Board!

What have you tried so far, and what were the results?

I think you're on the right track with an IF() function. Have a look at the Excel Help on IF() and post back with any questions if you don't understand how it works.

 

[owensmorgan]

Hi, thanks for the reply. I have used an if statement, but i dont know how to format the formula. Could you please help?

 

[slipstream]

Try -> =IF((F12/$B$8)*100>=71,"HIGH","")

:wink:

 

[Rusty]

Ok, if I understand correctly, try this:

Cell G12 would be:

=IF(F12>=($B$8*0.71),"High","")

Copy down for cells F13 to F18.

Any good?

 

[owensmorgan]

Thanks for the help all, ive sorted it now , ill probably need more help later on in the assignment

Thanks again
owen

 

[owensmorgan]

1 Other thing..Its sais-

"Use windowing and produce a screen print of your screen"

What is Windowing?? Anyone?
Thanks
Owen

 

[owensmorgan]

(B)

 

[slipstream]

Basic terms it's just a GUI (graphical user interface), windows is an example of a windowing system, dont really know what they want you to produce,

I'd say the screen dump you've provided would do.

 

[Tazguy37]

Try Print Scrn or Shift-Print Scrn.