# result

1. ### Subtracting times, negative result

Hi, I'm sure this is quite simple but I'm not getting it. I want to subtract to time values where the result (in this case) will be negative: Time A is entered manually as e.g. 13:30 Time B is a result of a calculation and shows as 16:00 The result should be -2:30?? I've tried different ways but...
2. ### Need to add multiplication to an array formula

Hello forum friends, I am trying to add a multiplier to an existing array formula but it is giving me, not an error, but the wrong result. The formula as it exists is returning a result of 24. I want to multiply this result by 0.621371 but when I add *0.621371 to the end of the formula and do...
3. ### COUNTIFS and SUMIFS Help

I am attempting to complete SUMIFS and COUNTIFS and am not getting any results. A sample formula I am using is: =COUNTIFS('Tracking Sheet'!\$H:\$H,"2016",'Tracking Sheet'!\$D:\$D,"Repaid",'Tracking Sheet'!\$D:\$D,"Closed") If I break the formula apart and only have two arguments, I get a result. I...
4. ### number of continuous 0s

Hello, I have a large table (100x200) which is updated daily. Cells are either 0 or 1. For each column and starting from row 2 I need to count the number of continuos 0 until a cell with 1 is encountered (e.g. today cells from K2 to K13 are all 0, H14 is 1 so the result should be 12...
5. ### Formula Help

Hi. I have the following three formulas: =B36+(99*B45) =(B37+B52) =B38+((99*B45)*52) And I would like to change each of them so that First one: from the result of the current formula, deduct the value of B49/4 Second one: from the result of the current formula, deduct the value of B49...
6. ### if formula not working and showing false result

<tbody> <tbody> 10000 </tbody> =IF(A8>0<=100000,25,IF(A8>100000<=500000,50,IF(A8>500000<=50000000,100))) result is showing false . why </tbody>
7. ### Formula

i need a vlookup formula let us suppose data is in sheet1 in column A and there is a data in sheet2 in column F formula will be placed in column K of sheet2 the result will be either true or false what i need is if data of column F of sheet2 does not match with column A data ( not with...
8. ### VBA Code to Work down a list, calc a result, add result to bottom of new list

Hi All, Any help here would be appreciated greatly. CODE SEQUENCE 1 Copy Item A from List A 2 Paste flat to B2 3 Recalculate the result to update C2 4 Copy range B2:C2 5 Paste flat to bottom of List B 6 Goto next cell on List A Repeat steps 1-6 Stop at bottom of List A...
9. ### To analyse Quarter monitoring from companies into power bi

Hi All Good Morning I have been asked to analyse Quarter monitoring fromcompanies into power bi The monitoring forms are in excel format with for Q1, and the other tabs would have Q2, Q3, Q4 tabs. the monitoring formformat does not change for each quarter. The information is input into...
10. ### dd-mm-yyyy?

I'm after some help! :confused: I have 3 data validation lists - E4 (01-31); F4 (Jan-Dec); H4 (2019-1969) and I want to check what the User selects - IF their input is ON or BEFORE 30-04-2013 the result cell will be 31.5 IF it is AFTER 30-04-2013 and the Users input is GREATER than 5 years...
11. ### Tax Calculation formula

Hi All, I have a formula I am having a heck of a time with, I need this to say, E8+E11*6% for the first 5000 and then over 5000 would then be charged 6%. The catch is I need it to retain the amount of the 1% for the first 5000 (\$50) E8+E11)*7% Eg 5000 would result in \$350 Eg 6750 would...
12. ### Football prediction formula

Hi I am trying to write a formula that will work out scores for me based on a set of predictions against foot ball scores - I have set out the table below. For each correct result, so for example you predict a 1-0 win and its a 2-1 win you get 1 point. For each correct result and score, so for...
13. ### Product + Sum (if)

It is possible to have a formula where i can add a sum to a product? And in my particular case, is it possible that the result of the cell have the sum of a value just only if there are particular conditions? MY case =PRODUCT(S15,0.3) I placed this formula in order to have the result of...
14. ### Extract unmatched of 9 patterns till the 9 patterns remains 0 and continue new search

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I have 9 unique patterns in the cells C4:K4 and some results in the cells D6:J44, My request is I need a macro which can extract unmatched patterns after the matching results out of 9 patterns and copy them in to N4:T44. </SPAN></SPAN> Start...
15. ### Help with FIND

I need a formula to extract the characters between the second and third hyphen in the strings below. <tbody> SAMPLE DATA RESULT 1-2-3-4 3 11-2-333-4 333 1-2222-3-4444 3 11111111-22222222-33333333-44444444 33333333 </tbody> Any assistance will be greatly appreciated! DJ
16. ### VBA adjusting an existing user function to operate on rows instead of columns

I need help adjusting an existing UDF to meet a new need. The script below is designed to take a vertical range of cells with comma separated values, then add all the values together and display the result in the same form- Like so... 6,4,1 5,6,1 3,2,1 ________ 14,12,3 Make sense? It works...
17. ### Regex: hidden "" after a substitution

Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...
18. ### equation

Hello, i would like to know what equation to use if i want to use the below condition if the result is 0% or in negative % then score is 0% and if result between 1% to 25% then score is 25% and so on till i reach score 76% till 100% then score is 100%
19. ### Array question

I have a array with 500 records and another array with 25 numbers. These 25 numbers are between 1-500. I want too clear all the records in 500 record array which are not in the 25 records array. Array1 10, 20, 31, 32, 45, 50 Array2 20, 45 After matching the result for array1 is 0, 20, 0, 0...
20. ### VBA or Macro to stop workbook save

Hi, I'm new to VBA / Macro and need your help on how to prevent the Excel workbook from saving if any cell(s) in a column has a FALSE result from the formula executed in those cells. The workbook can only be saved if all the cells in this column have TRUE result. Thank you for your assistance.