negative numbers

  1. T

    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...
  2. T

    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...
  3. T

    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...
  4. M

    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...
  5. W

    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...
  6. S

    Formula2 needed, please.

    <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)...
  7. G

    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...
  8. P

    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...
  9. S

    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...
  10. P

    Custom Format

    Is it possible to set a cutom format that will display the value -1 as CY-1, rather than as -CY1 ?
  11. C

    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...
  12. A

    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...
  13. E

    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
  14. R

    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
  15. T

    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...
  16. 2

    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
  17. R

    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.
  18. D

    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...
  19. E

    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...
  20. H

    Conditional formatting, formula for the top 5 negative numbers for a row.

    Row A1 - FX1 of negative/positive numbers -600 to 1100. I want to know which ones are the highest negative number (top 5) in the row. Thanks for your help in advanced.

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top