minus

Here is my code currently: Range("Y1").Select Range(Cells(2, ActiveCell.Column), Cells(WorksheetFunction.CountA(Columns(ActiveCell.Column)), ActiveCell.Column)).Select This is selecting all the values in column Y minus the header. I would like to select all data in Column Y:Column AO minus...

Hi I have observed the following error occurring on multiple occasions. Has anyone else seen this? To create the problem: 1. Name a sheet Y17M12 (I use that for December 2017 at my office). 2. On another sheet begin the following sumproduct & minus minus formula but ensure that you do not add...

I need to combine AND and OR in Excel IF statement and I'm not able to get the formula to return the correct answer. Any help would be greatly appreciated!! Example: If A1 is greater than plus or minus $50,000 AND A2 is greater than plus or minus 10%...

Hi guys, I have a spreadsheet. In one of the colomns I need the sum calculation to return 0 if it's negative and if it's over a certain number then I need it to return as that number as a maximum. Example: Cell A1 is 10, Cell B1 is 12, In Cell C1 I want to put a formula that tells me A1...

Hello Hopefully someone will be able to help I have a worksheet and i need some <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-top-style: initial; border-right-style: initial; border-bottom-style: dotted; border-left-style: initial; border-top-color...

Hello I am trying to automatically default some cells to a minus figure. I have seen you could do an ABS formula but wondered if there was an easier way? I only want to do some cells in the column as the others are positive figures. Thanks

Hi All, This is probably a really easy one for my first post but my formula skills aren't perfect. I'm looking to count working days between two dates (this part is easy - NETWORKDAYS) BUT, if the end date is open/incomplete, I'd like my count box to display custom text instead of a huge...

Hi, this is my first post, thank you in advance for any help you can give. I have a spreadsheet with multiple sheets (1 per student) Each student has the following 2 identical columns on their sheet Column D = Time added or time minus (added is when they buy, minus is when they use) Column...

Hi, can anyone help with a macro? I have Data on sheet1 - AJ2 has the row Ref and AK2:AQ for the Data and column AS to add 1 for every row used. I have two buttons on sheet2 I want to use as a Plus and Minus (E1 as Minus and F1 as Plus) I want to click the Plus button to add 1 to next row in...

Hi, I want to show result of different units per month, where one data series has minus. I want the total of the bars to show the correct totalresult of the company. The sum of the last column shouldnt be 13XX as shown here, but should be 1003. How do I fix this? BR

hi all... how to get the row number depend on data adjacent. the row always minus 1 row like that below : Excel 2007 <tbody> row A B 1 data expected result after formula 2 5 1 3 0 5 4 0 6 5 0 12 6 12 7 10 8 0 9 0 10 0 11 0 12 0 13 24 </tbody> any help...

I have making one calculation after giving formula I am getting resulted value either in minus or plus. Now I want another formula if a value I am getting in a particular cell, if it is in minus then add 365 in it and show the result but if plus then show the same value. so can someone help me...

Hello I am working on code but got stuck. [CODE] [Sub Test_SelRangePaste() Dim UserRange As Range 'On Error GoTo Canceled Set UserRange = Application.InputBox(Prompt:="Please Select Range", Title:="Range Select", Type:=8) For Each cell In UserRange y = cell.Address(False, False) x =...

Good Day, I am trying to write a formula to count the number of specific characters in a cell. This has proved successful to a degree utilising a LEN formula that I have listed below: =LEN(A1)+(1)-LEN(SUBSTITUTE(A1,"+","")) With the above formula I am counting how many times the plus (+)...

In my use of formulas when calculating numbers from a live data feed. Negative numbers are important, however I am looking for a method to remove the polarity of a number and have it represented as a whole positive number regardless if it was previously negative? Can some one help? Thanks

Is there a way to use Countif/s to count a row if the value in a field is plus or minus the value in the criteria range? For example, I might write =COUNTIF('Sheet1'!$A$2:$A$546,'Sheet2'!H2"-80"), and I would get an error informing me that there is a problem with my formula. I also tried adding...

I am trying to get excel to show what is left over 40. Is it possible? I do not want any negative numbers either. Here is an example: <colgroup><col><col></colgroup><tbody> 45.25 5.25 59.25 19.25 43.25 3.25 29.75 -10.25 30.5 -9.5 21 -19 </tbody> All I did was subtract 40...

<colgroup><col style="width: 75px"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"><col width="75"></colgroup><tbody> Score Yards/Point Yards / Play Offense Defense +/- Offense Defense +/-...

Hi guys, Please refer to screenshots below for reference. So basically I want to be able to keep track of how much vinyl material I have left after each order. The process would be - When I order a roll of vinyl material I would input the colour ordered and cm ordered by selecting from drop...

If i have A1 and i want to minus 30% off what would be the formula? Can anybody help please?