Need Help for my assignment.. :)

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-

help1.jpg

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

Can someone please help me out?
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.
 
Upvote 0
Hi, thanks for the reply. I have used an if statement, but i dont know how to format the formula. Could you please help?
 
Upvote 0
ADVERTISEMENT
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?
 
Upvote 0
Thanks for the help all, ive sorted it now :), ill probably need more help later on in the assignment

Thanks again
owen
 
Upvote 0
ADVERTISEMENT
1 Other thing..Its sais-

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

What is Windowing?? Anyone?
Thanks
Owen
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top