Positive & Negative values on Excel
Our take
I need a formula that will calculate the differnce from one column to the other in a row. However, sometimes the number in column A is bigger, and sometimes the number in column B is bigger. How do I get it to calculate the difference with the correct positive or negative value?
Im lookin for a formula that I can "set and forget" and copy the work books week to week.
Below is the table Im using. Its not an issue when the physical count value is larger than the TBS QTY value. But if youre looking at the last row, TBS is larger than physical, if I use the =sum(E-F) formula, I have to change the column numbers,(which If Im doing that, I might as well do the math myself) but week to week, the numbers change, and I dont want to have to change the formula each week, for each row.
Is this do-able, or am I just being lazy?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Correction on formula using sum and max to negate negative numberI'm trying to input an hour's punch as I'm a manager and I'm not punching my hours officially, but i want to calculate the excess hours. I need help with writting a formula to only have postive number, no negative. Here is the formula I'm trying to enter, but having error alert =Sum(max((0;(f61-c61))-(e61-d61))) currently having =SUM(F60-C60)-(E60-D60) i need help to correct my formula for only showing the result of it, and not the absence of result like now in the cell G61 as the cell F61 is empty. I would like the G61 only showing a result if both cell are completed. Thats why i dont want a neg number in G61 and inputing a 0 if the result of the formula is negative... I don't want a negative number on my g column cells. What would be the correct formula? a b c d e f g date start break end break end Total 2026-04-14 5.5 15.25 9.75 2026-04-15 5.5 15 9.5 61 2026-04-16 5.5 -5.5 2026-04-17 0 Here's a sample of the table im working with. Thanks submitted by /u/quebecoisbarbu [link] [comments]
- Inventory Tracking - Formula NeededPicture 1 is my Transactions sheet, picture 2 is my Order sheet ETA: Excel 365 in Chrome browser. Screenshots are from Excel iPhone app - but all work is done via desktop. I'm trying to pull a number from column G if the transaction ID in column I (picture 2) matches the TransID in column B (picture 1). I also want to make the number negative. Example - T8 is an order of 5 clusters, each cluster is made of 3 different balloons plus a weight, hence the multiple T8 TransID, 1 per item. My sheet already uses the Quantity column in picture 2 to update an inventory sheet - that's why I need to make the number negative. Is there a formula that can do this for me or am I completely overthinking this whole thing? https://preview.redd.it/i5m3zooym4kg1.png?width=1179&format=png&auto=webp&s=24bfc1a0ce96ce700b58b337b83d79a8381e1a86 https://preview.redd.it/dywqkooym4kg1.png?width=1179&format=png&auto=webp&s=030c2516253a4d305333dbdf65653c4a0a5ca0dc submitted by /u/Xxjustbrowsing666xX [link] [comments]
- Zero balance formatting. How to make appear positive 0 when value = 0 and not negative 0?I use excel for my checkbook. When the balance is $0.00 it is displaying in RED as ($0.00). How do I get it to display as $0.00 and not in RED. Searching didn't really help as it was making negative values positive. I just want to make $0.00 appear as normal positive number. The formula I am using is "=SUM(C5:C500)" If I use the formula "=LOOKUP(2,1/(C:C<>""),C:C)" then it does display correctly but that is just retrieving the last value. Not the sum of the column. Many thanks for any assistance! submitted by /u/RiverofGrass [link] [comments]