result

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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