1. Chris_010101

    Odd Result from Code

    Wondering if someone can help me with the below code. I got made redundant from a company and saved this code for use in the new job. It worked at the previous place but now, oddly, it's saving PDFs with the file extension ".22" (a 22 File). Never seen this before.. The idea of the below is to...
  2. F

    Copy Formula Result & Highlight

    Hey All, Could you please kindly advise as to what's the best way to loop through cells and paste as value a result from formula in another cell? If the result was copied, the cell should also be highlighted in yellow. In short, formula in column AY throws a desired result or states FALSE. If...
  3. R

    Formula result other than displayed

    Hello people, The formula I've written shows a zero as result, whereas when clicking the fx-symbol to check the formula, it shows the result will be 1; as expected. Who can tell me why I see a '0' as result in the cell?
  4. D

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

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


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

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

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

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


    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...
  11. J

    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...
  12. Leicester City Fox

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


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

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

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

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

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

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

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

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
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
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