TUTORING HELP with Nested IF Function within another function

[volcomgrl1223]

I am so stuck, could someone please help me with this:

"create a nested function that displays 'sunny' for any day that does not have an event observation and echoes other events. Nest the IF statement in a function that displays the results in uppercase letters"

I imported weather data from notepad to excel. One column has some data saying it was rainy or cloudy on those days. I know how to write an IF function, just not how to make it say 'SUNNY' on the blank days.

Please note, I did try to get assistance from a "tutor" at school. Needless to say Excel is not her forte. She couldn't be bothered to help with excel assignments.

Thanks in advance,

volcomgrl1223

[ConneXionLost]

Nothing is more frustrating than to be working on homework and to get stuck. Without guidance, you might have no hope of finishing the assignment before the deadline. The Internet can be a big help in that respect, but without learning how to get the right answer, asking others to solve your homework questions for you simply becomes a downward spiral (and it's cheating).

We do not want to contribute to you cheating yourself out of your education, but we also acknowledge that seeking assistance to learn a concept is a legitimate request.

If you are genuinely interested in receiving help in the form of tutoring or coaching, then please rephrase the title of your original post to clearly indicate you are seeking coaching or tutoring help. Any forum members (who are willing to assist as a tutor) will modify their responses accordingly to facilitate your learning. Tutors don't tell you the answers, they help you figure it out for yourself; so don't expect answers, expect suggestions, or just plain hints. Also, be specific in describing the function/formula or technique you trying to learn, and tell us what you have attempted so far. Otherwise, expect your plea for homework answers to be ignored.

To change the thread title, go to your original post, click EDIT then Go Advanced and change your title. If two days have already passed since the creation of the thread, ask a moderator to change the title for you.

[ConneXionLost]

To check for text in a cell, you could do something like:

Please Login or Register  to view this content.

To find where a cell is empty, is is common practice to use empty quotes like ""

[volcomgrl1223]

thank you, that was the issue, I didn't know what to do since some of the data was already filled in and empty cells meant "sunny"

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.

[kristindewitt]

You can take help of online tutoring, they will give the instant solution about C language. All the best!