Please help me with these questions--Thank you

**dannygina** · 10-22-2009, 02:32 PM

1. Use an IF function in cell B15 to calculate the Percentage of Class Space Filled.
Use the
• ISNUMBER function in the logical_test argument to determine if a number has been typed into cell C15. If the logical test is true, then display whatever number had been typed into cell C15. If the logical test is false, calculate the Percentage of Class Space Filled by dividing B13 into B14.

2. Create a nested IF function in cell B17 to display one of two different outputs. Use the ISNUMBER function in the first logical test to determine if numerical data has been typed into cell C14.
• If the first logical test is true, display the message “Numeric Data should be entered.”
• The second logical test should evaluate whether cell B13 is greater than B14. If cell B14 does not equal B13, display the message “Class is not yet Filled.”
• The nested logical test should evaluate whether Cell B14 equals Cell B13. If Cell B14 does equal Cell B13, display the message, “Class is Filled.”

**NBVC** · 10-22-2009, 02:33 PM

Welcome to the forum,

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.