Posts by Nathan Green76

Arthur Ramirez20 said:I'm typing some text in Word and I want it positioned right in the center of the page—not just horizontally centered (Ctrl + E), but vertically centered too. I don't want to have to hit Enter repeatedly and eyeball it to see if it looks right. Is there an actual option for this? I hope you catch my drift.🤷🤷🤷🤷🤷🤷🤷

I'm not entirely sure if there is a specific direct command for that—though there actually is—but you can always go to Page Layout - Paragraph - Spacing and set the spacing before the text to 350 pt. For a 12-point font, that should land you pretty much in the middle. If you're using a larger font size, just dial it back a bit—maybe try 348 pt—and that should do the trick...

ruggedcyclist7 said:Just upload the Excel file so I can take a look.

File name: Kf problem.rar File size: 16.47 KB

Give it a look if you can...

When I try to solve this using an iteration, I keep getting an error—I honestly can't figure out why. You can see the specifics in the screenshot here.
To clarify, I am calculating this KF value, which is also part of the formula on the right side.

I'm looking for some insight on how to handle this specific formula in Excel...

Basically, I need to assume a value for KF and run the calculation—then, once I have a result, I take that resulting KF, plug it back into the formula, and recalculate. I need to keep doing this until the difference between my calculated solution and the initial KF used is within a 5% margin.

Is there an automated way to handle this kind of iteration, or am I stuck doing it manually?