Microsoft Office Q&A: Ask anything (Word, Excel, PowerPoint, etc.)

Hey everyone, I could use a little hand here. I’m trying to tackle a task in Microsoft Excel but I'm feeling a bit stuck on how to approach it... Here is what I'm looking at:

In cell C2, I need to write a formula that looks at the percentage in cell C1 and assigns a grade based on this scale:

0%-50% = 1
51%-65% = 2
66%-80% = 3
80%-90% = 4
91%-100% = 5

Nathan Reed55 said:In cell C2, you'll want to enter a formula that looks at the percentage in cell C1 and outputs a grade based on this specific scale:

=1+(C1>50)+(C1>65)+(C1>80)+(C1>90)

Now, I'm assuming that the value sitting in C1 is just a plain number representing a percentage—say, 62. If you actually have it formatted as 62% within cell C1, then you'd need to adjust the formula slightly like this:

=1+(C1>50%)+(C1>65%)+(C1>80%)+(C1>90%)

Just... make sure that whoever gave you this assignment actually understands how the logic works if they ask you to explain it.🙂.

Nicholas King said:=1+(C1>50)+(C1>65)+(C1>80)+(C1>90)

The idea here is that you've got a number in C1 representing a percentage (say, 62). If you're actually typing "62%" into cell C1, then go with this:

=1+(C1>50%)+(C1>65%)+(C1>80%)+(C1>90%)

Just make sure you can actually explain how the logic works if whoever gave you this task asks. 🙂.

Could you maybe walk me through this a bit more? Or better yet, just whip it up in Microsoft Excel, upload it somewhere, and DM me the link...

Thanks!

Nathan Reed55 said:...or just build it in Excel, upload the file somewhere, and shoot me the link via DM....

Just copy and paste these formulas directly into Excel and you're done—why bother with an upload at all? 😕

Nicholas King said:Just copy-paste these formulas into Excel and you're done. Why even bother with an upload? 😕

I don't know... I just can't... look, please, if it's really not that big of a deal, just upload it for me.

Nathan Reed55 said:It’s not that I don't want to... I just—look, please, if it isn't such a huge deal, could you just upload it for me?

Can you actually describe what's happening here? Like, when you type a number between 1 and 100 into cell C1, and then you either overwrite or paste one of those two formulas I provided into C2, what specifically occurs?

Even this level of assistance is pushing the limits of academic integrity; sending over a finished, solved file is definitely crossing the line from helping to outright cheating.

Nicholas King said:Can you walk me through the problem more clearly? If you type a number between 1 and 100 into cell C1, then either overwrite or paste one of those two formulas I gave you into C2—what actually happens?

Even this kind of help is pushing it; providing a finished, solved file would definitely be crossing the line from helping to just doing someone else's homework for them.

Everything works now, I just managed to screw something up myself 🙂 thanks so much for the help

Hi there.

I've run into an issue with Word, specifically involving the HRTimes font.

Here is the situation.

We share Word documents across several different computers here at the office. One workstation is running Office 2003, while the rest of us are using Office 2007.

Lately, when opening a document on that older Office 2003 machine, some of the text set in HRTimes isn't displaying as part of the Times New Roman font family. Instead, it keeps defaulting to some kind of Arial italic :/

The weirdest part is how inconsistent it is. It’s totally random—out of ten times I open the file, it looks fine seven times, but three times it shows up completely wrong.

goldenheron24 said:Lately, on my machine running Office 2003, whenever I open a Word document, certain sections written in the HRTimes font aren't showing up as part of the Times New Roman font family—instead, they show up as some weird Arial italic version :/

One potential route would be "hunting for patterns"—I suppose you could try to figure out exactly when and why the formatting starts to break down.

A second, perhaps more straightforward option might be setting up a macro within Word 2003 that would simply force the entire document back to the HRTimes font. You could just assign the macro to a button, add it to your toolbar, and click it whenever things go sideways.

BTW, I can't even remember how many years it's been since I last heard of anyone actually using HRTimes—I mean, why isn't standard Times New Roman good enough for you people?

Hey,

I'm working in Excel (2010) using nested dependent drop-down lists. If I pick "Fruit" in the first menu, the second one gives me options like banana, apple, or pear. That part works fine. What I actually want is to have an option in the first list that says "Select then Fruit," "Select then Veggies," etc. That's working too. But I can't figure out how to make the second drop-down reset to blank whenever I select that initial "Select" option—I need it to look like nothing was picked. Also, I've got a headache with cell height. I want the row to auto-adjust to the content, but it only happens if I manually trigger the autofit command. I don't want to click that every single time; I want it to be automatic. How do I fix these two issues?
My goal is to pick "Fruit," then "Banana," and then have a description of the banana pop up in the next row. It's almost there, but these two bugs are stopping me. Need help fast. 🙂
Thanks.

Hey there... I could really use some help. I'm trying to add page borders to my document. I want wavy lines at the top and bottom, and maybe some kind of effect along the sides... I have no clue how to pull this off. Any advice?

urbantrucker61 said:Hey there... I could really use some help here. I'm trying to insert some page borders... I want wavy lines at the top and bottom, and then some kind of decorative effect on the sides too... I have no clue how to actually pull this off. Help me out..

Look, you need to go to Format, then Borders and Shading, then select Page Border. Under Style, look for that wavy line option. Once you're there, check the Preview area—you'll see two little boxes on the left side which control the top and bottom borders. Double-click those to get your wavy lines set up. After that, go back to Style, pick out a fancy decorative line you like, and then double-click the boxes in the Preview section at the bottom to apply them to the sides. That should give you the wavy top/bottom combo with the decorative sides you're looking for.
I'm running Windows XP and Word 2003 on my machine.

Hey everyone. Quick question—does anyone know how to set up a many-to-many relationship between two tables in Microsoft Access? I’m working on a specific setup involving menu items and receipts... I need to link them so multiple food or drink items can show up on a single receipt, and the same item can appear on several different receipts. Right now, I only have a one-to-many relationship, but I definitely need it to be many-to-many. Any help would be huge! Thanks in advance

Check it out, there's a similar example right here: http://ms-access-tips.blogspot.com/2...ationship.html

Hey everyone—does anyone happen to have Word 2013 installed in American English? I’m working on a seminar paper and need to grab a few screenshots for it. Thanks!

Hey, does anyone know how to actually type text after the bibliography in Word? It’s acting like that area is locked off for references only, so I can't get anything else in there. I know there's a workaround based on some stuff I saw online, but I can't figure it out. 🙂 Apparently, you need to insert a section break, but every time I try that, my entire list of references just vanishes... 🙂 Help.

What on earth does "writing after references" even mean? You write just like you always have—you tell Word where to put the citation (usually at the bottom of the page) and that’s about it.

It would be incredibly helpful if you could provide a more specific🙂 description of what exactly you are trying to achieve.

I would appreciate some assistance. I have a term paper drafted in Word, and I need to save it onto a CD. I haven't been able to find the right way to go about this—perhaps I should convert it to a PDF first? If anyone knows the best approach, please let me know.

Thanks! 🙂

You’re burning it just like you’d burn any other file onto a CD—it honestly has absolutely nothing to do with Microsoft Word.

Converting to PDF is always a smart move in these situations, though—not because of the CD burning aspect, mind you, but more because of the whole "locking in the formatting" thing.

I’d highly recommend converting everything to PDF. My professors back at college used to send my papers right back to me because the formatting would just fall apart on their end—tables would shift, diagrams would go haywire, and formulas became unreadable... sometimes they couldn't even open the file at all.
My instructors are still using software from like, 1999, while I’ve moved up to AutoCAD 2014 😉

PS: Just in case some federal agency is tracking my every move for doing something shady, I’m definitely just using free student versions! 😉