Posts by Bradley Murphy56

Walter Jackson48 said:Try rewriting the first part of your formula—instead of using =IF(D39:D40=7...), try something like =IF(SUM(D39:D40)=7... or even just =IF(D39+D40=7...
and
in the future, when you're posting formulas, please disable those smiley faces.

Thanks a ton. You really helped me out here.

Best regards!

=IF(D39😁40=7;ROUNDUP(AS40/12;0);ROUNDDOWN(AS40/12;0))

If the sum of cells D39😁40 equals 7, the formula should round up to the nearest whole number—but if that condition isn't met, it should round down instead.

BUT—and this is a massive "but"—I am clearly doing something wrong because it’s just not working. It keeps rounding down regardless of what I do.

HELP ME out here.

Well, there you have it. That's the whole story.

frozenheron7 said:If your new price is just "price times area," then you should probably just use this formula:
=IF(A2<>0;A2*B2;"")

-> This works for your second row—assuming, of course, your headers are in the first row. Just drag that formula down through all 100 rows by grabbing the little black square in the bottom-right corner of the selected cell.

Bradley Murphy56 said:Here’s what I’m looking at:
Column B contains prices, while column A holds the area. Column B is filled with values from row one to row one hundred, and there's a total price at the bottom. Column A isn't fully populated because some rows have a value of zero. Now, I want to know how to make a specific cell (let's say in column C) calculate only those prices where an area is actually entered—not the grand total, since the total is already sitting at the bottom.

Is that even possible?

Well, since that answer didn't exactly hit the mark, let's try to simplify things a bit.

Suppose we put these numbers in column A: row one is 1, row two is 0, row three is 3, row four is 0, row five is 5, row six is 0, row seven is 7, row eight is 0, row nine is 9, and row ten is 0.
In column B, let's put 10, 20, 30, 40, 50, 60, 70, 80, 90, and 100 for the first ten rows.
What I need is to sum only the values where the corresponding entry isn't zero. In this case, the result should be 250. But how on earth do I get the software to actually calculate that?

Here’s my dilemma:
Column B holds the prices, while Column A lists the surface area. I have values filled in Column B from row one all the way down to row one hundred, with a grand total sitting at the very bottom. However, Column A isn't fully populated—some rows show a zero value for the area. Now, what I’m trying to figure out is how to make a specific cell (let's say in Column C) calculate *only* the prices that actually have an associated area next to them—and I don't mean the grand total at the bottom, which, as I mentioned, is just sitting there at the end.

Is this even possible?

How on earth am I supposed to insert a screenshot here so I can actually show you what I'm talking about?

I’ve put together an Excel spreadsheet based on an EK-1 template I picked up at a local office supply store. My plan—which seems simple enough on paper—is to feed the pre-printed, blank form directly into the printer and have the computer fill in the blanks, like names and birth years. The problem? Every time I try to print, the whole damn table prints out instead of just the specific data points I added later. How can I print *only* the stuff I typed in (for instance, the names and dates) without wasting ink on the entire layout?

Well, things have slowed down. That should be about it for now. Talk soon.

I’m trying to lock certain cells in Excel while keeping others wide open for data entry. For instance, I need the name and surname fields to be completely locked,
but the cell right next to them needs to stay unlocked so someone can actually type in it. I tried messing around with the "Format Cells" option to lock the cells and then protecting the workbook,
but frankly, I haven't quite grasped the logic behind it. It keeps locking things that should stay free and leaving things open that ought to be restricted—it's maddening. Is there a more intuitive way to handle this?

There is a trick where you can set it up so that when you use the arrow keys to navigate the sheet, you only jump between the specific cells that are actually open for input.