# negative numbers

Any idea?
2. ### VBA check for negative numbers in column and add text in corresponding cell in a different column

Hi, please help. This macro is supposed to check in column Z to find any negative numbers. If it finds a negative number in a cell, then in the corresponding cell (same row) in column I, it's supposed to put in a message "Applied payment". However, it gets stuck on the line I highlighted in...
3. ### How do I multiply a negative number by a positive factor and get a less negative number?

Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me if I make a mistake. Question: How do I multiply a negative number by a positive factor and get a less negative number? Hypothetical Example: -2.0 * 1.1 = -2.2. But...
4. ### Nested IF: return "High" if cell value is >5, "Low" if <-5, and "Mid" if in between

I've tried so many options but it only seems to return one answer. E.g. The values I have are [A1] 41, [A2] 0.08, [A3] -2 and [A4] -13. In B1 I have: =IF(A1>5,"High",IF(A1<-5,"Low","Mid")) This returns "High", which is correct. But I drag it down into B2, B3, B4 and the cell ref A1 changes to...
5. ### Prevent Negative Numbers in a column

Greetings to all! I just joined this forum so that I can learn from the experts and contribute as much as I can. I have a situation for which I am looking a solution for: I have three sheets in my excel file to manage inventory, namely, Demand, Supply, Inventory. Let us say that an article in...
6. ### percentage difference between positive and negative numbers

Hello, Please refer to the table below I have been trying to create a formula to show the percentage increase between the 'without' row and the 'with' row. I've tried ((without - with)/with) and also included the ABS command to try and solve the negative number issue but the results are less...

<tbody> srl# Month Voucher Source Amount Formula1 Formula2 520 Sep-11 5003750 Inventory (1.43) 1114 Sep-11 5003750 Inventory (15.73) (17.16) Negative 92 Oct-12 5005762 Purchasing 1,778.00 93 Oct-12 5005762 Purchasing 2,834.80 2872 Apr-14 5005762 Inventory (2,834.80)...
8. ### Help with IF statement and negative numbers

I'm not an Excel novice, but my brain is just not seeing how to appropriately do this. I'm hoping maybe there's a function I've never used before, so I'm not aware of it. Or maybe I'm simply too close to the problem and not thinking outside of the box. But either way, my issue is follows: In...
9. ### Difference Ignoring Negative Numbers

Hello, I am trying to find a formula that will find the difference between two columns but ignore negative numbers in any of the columns. Column A ("Gross Reserve") is a reserve for an insurance claim (the amount we expect to pay) and Column B ("Amount Paid") is the amount we have actually...
10. ### Formula To Show The Percentage Of A Negative Or Positive Amount

Hello, I've poked around on a bunch of forums for a few days and did a lot of searching around, but most of the results I've found aren't what I'm looking for. Attempting to take a percentage of a single positive or negative value. The current formula that I'm using seems to work, but when...
11. ### Custom Format

Is it possible to set a cutom format that will display the value -1 as CY-1, rather than as -CY1 ?
12. ### Trouble combining negative numbers - me or my formulas?

I am either doing something wrong or Excel is not handling negative numbers the way I expect it to. I have data tab (similar to the dummy table at the end of this post) which has several million dollars posted on several thousand rows. I have summary that shows the costs incurred for Bob...
13. ### Difference on number line between two numbers and indicating more "positive" or "negative"

<TBODY> I have hundreds of data points, I manually go through each week from testing and type it in correctly. It may be an easy fix but I have gone way too deep in the rabbit hole on this one. I have totally confused myself. It looked easy at first. Is B6 more negative than A6 and by how...
14. ### Deleting cell contents which contain negative values

Hi I'm trying to clear the content of cells in a large table that contain a negative value using some VBA. Any help greatly appreciated. Thanks Emilie
15. ### Configure formula to show negative number result as zero.

Using simple multiply and divide formulas. In some cases the resulting product is a negative number. In those cases I want to display "0" instead of the negative value. For instance: If 3 * 5 = 15 then I want to display 15. But if -3 * 5 = -15 then I want to display 0. Any ideas? Thanks, Rick
16. ### How to find nth negative time in list?

Hi all I've got a grid that is set to show the number of minutes from 3 days down to -1 day, each cell is different depending on data from another sheet. I've worked out how to list the nth positive number from 0 mins: =iferror(SMALL(rpd_data!\$G:\$G,COUNTIF(rpd_data!\$G:\$G,0)+1),"") but i can't...
17. ### IF function using negative numbers an 3 options

I'm trying to make a cell do the following : if cell H12 is above 5 show "above", if it is below -5 show "below", if it is between -5 and 5 (not including 5 or -5) show in line. Can anyone tell me what I need to type in... I have tried all sorts !:confused: Big thanks in advance
18. ### Excluding Negative numbers in a sum formula.

Im trying to find out how to ignore negative values that on a row in my formula in excel. Here is my formula. =SUM(F12,H12,J12,L12,N12,P12,R12) Is there a way to exclude any negative value that is in a cell? Thank you.
19. ### Large function doesn´t include negative numbers

Hi, I have a table like this A B C D E <TABLE style="WIDTH: 339pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=452 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 48pt" width=64><COL...
20. ### text determines value

Hi all, New to the forum and also Macros. I am trying to write code to make a cell default to a negative value based on the text of another cell. For example: if the cell states "EXPENSE" then the offset(0,1) will be a negative figure when the numbers are entered into that cell. Any help...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back