# Need Help for my assignment.. :)

#### owensmorgan

##### New Member
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

Thanks
Owen[/img]

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
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.

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

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

:wink:

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?

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

Thanks again
owen

1 Other thing..Its sais-

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

What is Windowing?? Anyone?
Thanks
Owen

(B)

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.

Try Print Scrn or Shift-Print Scrn.

Replies
3
Views
290
Replies
1
Views
200
Replies
6
Views
934
Replies
11
Views
159
Replies
0
Views
1K

### Forum statistics

1,196,460
Messages
6,015,376
Members
441,889
Latest member
balolaptopgiaolong

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back