Posts by Jack Hayes

Timothy Reed7 said:Hey everyone,
I need a little help with logical functions (like IF, AND, and OR) in Excel. Here is my situation: I have two different sets of conditions that need to be met. For example, either Column A >= 10 AND Column B >= 2, OR Column A >= 15 AND Column B >= 3. If one of those pairs is true, I want it to say YES, otherwise NO.
I tried typing in this formula: =IF(AND(A3>=10;B3>=2;"YES");OR(IF(AND(A3>=15;B3>=3);"YES";"NO")))
But for some reason, I keep getting an error message: #VALUE!

Thanks so much for the help,

Best,
S.

=IF(OR(AND(A1>=10; B1>=2); AND(A1>=15; B1>=3));"YES";"NO")
Just take a close look at how the parentheses are nested and how the conditions are checked.
The AND functions handle each pair separately, then the OR checks both of those results, and finally, the IF evaluates everything inside the brackets.☕

Michael Booth43 said:Quick correction on my last post—everything was going smoothly while I was just typing away, but then I realized I actually need to open some specific files that require Microsoft Word specifically, and they aren't working for me right now.

So, sorry about that! I really need a solid version of Office from back in 2010 for school. One version I downloaded ended up being full of viruses, and another one just wouldn't even launch.🙄

I'm a little confused by the "have to use Word" part. Have you tried opening those Word documents in LibreOffice Writer? It handles both .doc and .docx formats pretty well. Unless, of course, the file has some crazy formatting quirks that only the official Microsoft software can process properly.

Michael Booth43 said:I’ve tried downloading a few different versions of Microsoft Office for my thesis, but nothing seems to actually work. Did any of you guys run into similar issues while working on your papers? Any recommendations on which version I should grab that won't crash on me? I'm in a bit of a time crunch since I need to finish this entire report by tomorrow.🙄

Have you tried the free version yet? I've been spending quite a bit of time lately playing around with LibreOffice. It’s actually pretty interesting to see how much you can get done with it! Sometimes I find myself missing the familiarity of Microsoft Office, but there's definitely something to be said for having these different tools at your disposal. It keeps things interesting, you know? Or are you really holding out for Microsoft Office?

Brenda Lee2 said:I need a hand with this formula. I'm using =IF(D26=15;"JUB";" "). It works perfectly fine when I just want to check for one specific number like 15, but that's not quite what I'm after here. What I actually need is a way to make the function work if I enter any of these numbers: 5, 10, 15, 20, 25, 30, or 35. Basically, if I type in something like 1 through 4, it should stay blank, and if I type 6 through 9, it stays blank too.

Are you trying to pull out all the numbers divisible by 5? You could try using =IF(MOD(D26;5);" ";"JUB "). This will spit out "JUB" whenever the remainder of the division is zero.

Kyle Johnson2 said:That’s an interesting little puzzle, though it looks like you managed to crack it using the tips from @Jack Hayes/">@@Jack Hayes
The idea itself isn't bad at all. For me, though, it feels a bit cluttered. Personally, I’d lean on the power of PIVOT TABLE instead—definitely give that a thought for next time! 😉
Cheers to Jack Hayes 😉

A pivot table is an absolute beast, but for a straightforward issue like this, sub-items work just fine. It doesn't feel messy to me. If anything, keeping the table structure identical is actually a plus for the user, especially since they get those extra sub-item rows. Plus, you get those handy little buttons (1, 2, 3, etc.) right up there by the column headers—perfect for toggling specific sub-groups you might want to copy over...
Best! 🙂

brightstag1 said:Awesome, thanks 🙂

I have one more question, if you don't mind 🙂
Let's say I have columns set up like this: date, category (fiction, non-fiction, pop science, etc.), and the number of books received on that date.
I want to calculate cumulative totals—basically, the running total of books specifically for the "fiction" category per date. How do I pull that off?

Just follow the same steps from my last post, but this time select "for each change in:" CATEGORY and make sure to uncheck "Replace current subtotal." So, first you add a subtotal for every change in date, and then you add another subtotal for every change in category. Just ensure the sort order is by date and then by category. 👍

brightstag1 said:Hi there,

I'm trying to put together a quick little table to track how many books come into the library on specific dates—plus a running total for each day. I'm a bit stuck on the terminology, though. In this context, is "cumulative" just another way of saying the sum, or am I missing something?

Thanks!

Just sort your table by date, then head over to the Podaci-Podzbrojev menu. Under "subtotals," pick DATE, select the sum function, and then highlight your BOOKS field
.

Ryan Sanders83 said:I can't quite remember the name of that free alternative to Word I can grab online—does anyone know what it's called or where to find it? 🤔
I need it for drafting some applications and stuff...

LibreOffice 👍

Daniel Doyle88 said:I haven't had the full Microsoft Office suite on my computer for quite a while now—no Word, no PowerPoint, not even Excel. To make matters worse, I don't have a disc to reinstall anything. Is there really no way to just download the whole thing from somewhere online? I actually really need it right now.🙂

Have you thought about just installing the free version, LibreOffice instead of Microsoft Office? 👍

Just paste the image into Microsoft Word; you can add shapes, lines, connectors, callouts—whatever you need to get the job done. Just make sure to turn on the Drawing toolbar under the View -> Toolbars menu. Does it really have to be Word, though? Why not try some open-source software instead?

Have you tried plugging in a different monitor?
Sounds a bit silly, doesn't it?
I actually remember this one guy describing a similar black screen issue once.
He went through the whole routine of testing everything—graphics card, hard drive, motherboard... but nothing worked. He didn't even think to check the monitor because his BIOS loading screen looked perfectly fine. 🤷

Adobe Acrobat is the absolute gold standard. It’s lightweight and incredibly fast. I love how you can highlight text just like you're using a physical highlighter on actual paper. Plus, being able to fill out forms and save them directly is such a lifesaver. Seriously awesome!!!👍

analogsailor40 said:Hey, just dropping this here so I don't clutter things up with a new thread. 🙂

So, I need to wire some cash to someone's checking account over at JPMorgan Chase.
The only thing tripping me up is the "payment reference" part.
There are two separate boxes—what goes in the first one versus the second?
A friend told me to just put their account number in the second box...🤷 but what about the first one?

Usually, I just pay my bills through JPMorgan Chase and have never actually sent money directly to an individual like this, so I'm totally lost.

Thanks! 🙂

Your friend is right. For the reference number, you just enter the recipient's account number, and for the model field—just use 17. 👍