frozenraven10 said:How do I go about adding more arguments into a function? Something like this: =IF(A2>B2,1,0)
Look, if you want to expand that logic, you don't just stop at the zero. You swap out that "0" for a whole new IF statement. It’s basically nesting them, which can get messy if you aren't careful, but here's how it looks: =IF(A2>B2,1,IF(A2>C2,0,IF(A2>D2,2,IF(...... and so on until you're done
Sure thing. You just need to set up two different sections, then you can assign specific margins to each one individually. (Just head to the end of your first page, go to Insert, select Break, choose Next page, and hit OK.) That way, your first page stays as its own section, and everything from the second page onward becomes a completely separate section.
Alright, here’s yet another attempt at guessing what you people actually want from me:
Let's say cell A1 is filled with some nonsense like: "word1, type, iron...", and if we want D1 to spit out "word2", then we just drop this formula into D1: =LEFT(A1;5)&"2". If the question weren't such a vague mess, maybe I could give you an actual precise answer instead of playing these guessing games.
Or, look, if you’ve got "word1" sitting in cell A1, but you’re dead set on having cell B1 spit out "word2" instead, then just pop this into B1: =SUBSTITUTE(A1;1;2).
Jessica Brown25 said:Well, thanks so much for putting in the effort there; it was actually a really clear explanation.
Take a look back at my post from April 11, 2012, over on page 83 of this forum. My breakdown was specifically aimed at the 2003 version, but it should still give you some useful context. Just search through this zbirni thread—there have been tons of comments added to it over the years.
urbanbison8;39096730 said: How can I make Excel recognize when I type something like "Go" (for vacation time) as the value 8 (eight hours) instead of just text, so it actually works in my hourly tracker?
Look, you might be able to fix this using a formula like =COUNTIF(C9:AG9,"Go")*8. Basically, the formula counts every instance where the word "Go" shows up and then just multiplies that count by 8. Simple enough, right?
So, let’s say you’re looking at a three-page setup: you've got your cover page, then the table of contents, and finally the introduction. If I'm following your logic correctly—and I try my best to keep up here—you actually want that third page, the intro, to be labeled as page "2." It sounds counterintuitive, I know, but if that's the goal, here is how you handle it in Word 2007: First, go to the very end of that first page (the cover), hit Insert, select Break, click Next page, and then just hit OK. Once you're sitting on that second page (your contents), head over to Insert, then Page Numbers. Make sure you uncheck the box for Show Number on First page. Then, go into Format, set the starting number to 1, and hit OK, OK. That should force the system to display the number "2" right there on your third sheet, the Introduction.
driftingcanyon16 said:I remember there being some sort of way to use boxes or frames in older versions of Word to type things in, but I just can't track it down anywhere. thanks :mig:
Maybe this will help you out (works for both Word 2003 and 2007): Wherever you want that title to sit, just go ahead and insert a Text Box (go to Insert, then Text Box) and type your heading right there. Once it's typed, move it where you want it, then right-click it and change the border lines to white so they disappear into the background.
Kyle Johnson2 said:Have you even tried it? It’s not going to work. :mig:
Look, I’ve already tested this. It’s straightforward. It works on both the older versions and Excel 2007. In my specific setup, you don't even need to have data populated in column B to make it happen—though in your case, it sounds like you might need those values entered beforehand for the logic to trigger. Best,
Rachel Hill23 said:Well, that didn't work for me either.
Look, I just used a basic logical formula: =IF(B1="";"";b1*2) typed right into cell A1, and it works perfectly fine on my machine. Now, sure, if you drag that down, you're technically copying the formula into every single cell in column A. But—and this is the part that seems to be getting lost in the shuffle here—by using the IF function, you've actually limited what shows up. You aren't cluttering the sheet because the formula tells the software to leave the cell blank if the corresponding cell in column B is empty. It’s pretty straightforward logic: If B1 is empty, show nothing; if B1 has data, then calculate the result, which in this case is b1*2. Of course, you'll obviously be using whatever specific math you need instead of b1*2.
There might be some slicker ways to handle this, but give this a shot: Go ahead and grab the formula from the first cell in your column—just hit Copy. Then, move up to the top of the column until your cursor turns into that little arrow, click once to select the whole thing, and just hit Paste.
Maybe this formula will do the trick for you: =OFFSET(COLONA;COLUMN()-COLUMN($E$1)+((ROW()-ROW($E$1))*(ROWS(COLONA)/1));0;1;1).
Look, here’s how it works—if you have, say, 10 numbers sitting in Column B, just select those numbers and give them a defined name called COLONA using the Name Manager (you find that under the Insert tab). Then, go to cell E1, drop this formula in, and drag it to the right so all 10 numbers have a place to land. That "/1" part at the end? That’s what forces everything into one single row. If you wanted to split them into two rows, you'd change it to "/2", and so on. It's a bit finicky, but it works if you follow the steps.
Actually, before you go down that rabbit hole, just try this instead: copy those numbers from your column, go to wherever you want the row to start, right-click, hit Specialty Pasta, then select Transpose and click OK.
I'm trying to figure out how to set up an Excel sheet with two date columns. One needs to be the current date that updates itself automatically every single day, and the other is just a fixed deadline date. On top of that, I need to know how to subtract them so I can see exactly how many days are left until the deadline hits.
To get that live, updating date, just use this formula: =TODAY(). As for keeping tabs on those deadlines, you can try this one out: =IF(TODAY()>D8;"Deadline passed";"") Basically, if you plug your expiration date into cell D8, then throw that formula into E8. What it’s doing is simple logic: If today's date has already jumped past the expiration date you set, it'll spit out "Deadline passed." If we haven't hit that date yet, it just stays blank. Pretty straightforward once you see it.
Between what @IvanC suggested and this little trick here, you should probably have this whole puzzle sorted out by now.
I’m not entirely sure I follow what you’re getting at here... but look, just try making that specific section its own paragraph. If you've got a chunk of text sitting right at the top of your document, just scroll all the way down to where you actually want that text centered and hit Enter. Once you've done that, highlight the part you want to move, find the alignment tool in the toolbar, and click center. That should do the trick. There might be other ways to hack it together—I'm sure some tech wizard will chime in—but if you can just explain exactly what you're trying to achieve, someone else might be able to give you a hand.
Go ahead and hit Insert, then select Picture or Clip Art. You can use the Search bar to find exactly what you're looking for—just type it in, click on the image you want, or if you're feeling particular, click that little arrow next to the picture before hitting Insert.
Maybe give it a shot like this: Split the document into two separate sections. Set the first page as Section 1, then make everything else Section 2. Go ahead and set up a header on that first page, then flip over to the second one and delete the header there—that way, it should stay put on the first page and nowhere else.
So, what exactly do you think that "10" is doing in your formula? If your actual goal is to multiply 10 by whatever is sitting in cell B4, then you need to stop overcomplicating it and just try entering 10*B4 (instead of using 10;B4