write

hey guys, i have a VBA coding problem and i am not sure if i need to write in index/match formula into my vba or if theres a better way to build this. I have a list of numbers <tbody> <tbody> 1 test1 3 test2 5 test3 8 test4 11 test5 13 test6 15 test7 </tbody>...

I am trying to write an IF function based on 3 conditions. It will test the following (A3+B3)*.1 = answer. If the answer is less than 150 then display 150. If the answer is greater than 400 then display 400. If the answer is between 150 and 400 then display answer. I have tried a nested IF...

Hello everybody. I'm grasping data in the web via Excel. I'm stuck in inserting a date in a calendar: how can I write the desired date in this one? <td class="Input" style="width:100%;"><span id="Date1_dateInput_wrapper" class="riS RadInput RadInput_Black"...

hi every one, i trying to wirte time in below formate but facing problems <tbody> Available data Need to write 3:50 3 Hr 50 min 2:15 2 Hr 15 min </tbody>

How can I write a =concatenate formula that says this =concatenate(BD:BD,"/"BE:BE) BE2 has a #N/A in it. How can I write the formula and have it return only what is in BD and remove the #N/A? or Is a =if statement a better option?

ı am new vba and here. I am working on stocks and ı need your helps. so firstly as you can see on tittle, ı want to choose automaticly in down list what i write on my excel. So ı need amortization information from this web site website in "MALİ TABLOLAR"page amortization in turkish is amortisman...

Hello, I have big problem. I want to make a 1,2,3 biggest numbers but there is two simillar so exel write two same words, how should I write the formula? =INDEX(A4:A16;MATCH(LARGE(H6:H16;{1;2;3}); H4:H16; 0)) How should I correct this formula? If it need, i can add the photo. P.S. sorry for...

Hi, ill try and make some sense here... ok, If I write "13:00" in a cell and format as a number I get "0.541666666666667" If I write 07:00 in A1, "07:15" in B1 then use the handle and drag to the right.. the 13:00 in this series formatted as a number is now "0.541666666666666" (Note the last...

Hi, I'm trying to write some VBA code that does the same thing as this Excel Code: {=PERCENTILE.INC(IF($A$2:LASTROW=A2,$AF$2:LASTROW),.5)} I know of the function: [code]Application.WorksheetFunction.Percentile( but not sure how to use it. Can anyone help me out please? Thanks!

I've got a worksheet with all the data in 1 column in the following sequence: date, name, data, comment, number, blank repeating for a month. I need to move the data cell and the number cell to the right to the date. So I am trying to write a simple loop: For each date in the worksheet...

Wish you all Happy New Year Hello 1. What would be the syntax for the following to write in txtAmt.text =IF(AP6<$D$2,AQ6,0)+IF(AS6<$D$2,AT6,0)+IF(AV6<$D$2,AW6,0)+IF(AY6<$D$2,AZ6,0)+IF(BB6<$D$2,BC6,0) the above is written in BF6 Cell so that anyone opening the sheet gets the cell value as...

I am running an end of year report. I want to highlight 2018 figures if it is blank AND 2017 has a value. How do I write this if/ and statement. We are looking at where we lost money.

Hi good after noon, I am using an excel chart and finding solution to restrict cells in a row for writing, if a particular word will write in a CRITERIA cell the restriction will remove to allow for writing. <tbody> A B C D 1 DESCRIPTION VR / KYC AMOUNT 2 Transfer (ALLOW TO WRITE)...

Hello all! I have a spreadsheet that I entered a check mark (letter "a" in Marlet font) into set boxes. I want to write a formula that tallies all those boxes containing an "a" check mark in a given row. How would I write it? Below is an example of the boxes- although it didn't copy right...

Hello, I want make a calculation and if negative to make it zero, while if possitive to leave it as is. I write it as: []=IF(($D$123-D30*$D$10/$D$21)>0,$D$123-D30*$D$10/$D$21,0)[] Is there a way to make it shorter without having to repeat it twice in the formula because it gets very long...

I have a little bit of VBA code which reads a 13MB binary file into memory. Once there I want to edit it and write it out to a second file. The problem is, using the write command, (WRITE #2 ,a$ - where a$ is my edited 13MB string), I get chr(34)'s inserted at the beginning of the output and...

Im trying to write a formula into a cell, which will later be copied down its column but Im struggling with understanding how to write the formula in vba so it is suitable to be copied down. The formula will be written to the right of a set of data which has a variable number of columns but...

With Workbooks(COMBINED).Worksheets(NameVar) .Range("A6", Range("A6").End(xlToRight).Offset(-1, 0)).Copy I have an "application or object defined error" on the lower defined line of code. How is the correct way to write this? I would like to be able to copy a range from "A6: some column...

Hello. I came up across a problem: I want to add a range of values in a single cell but cannot seem to find a solution for this. For example: In cell A1 I want to write 1-12 and in cell B1 I want to write 25-28. A1 B1 2-13 25-28 Now, I need the answer to A1 to be 12 and the answer...

Hello, I'm trying to categorize a number in a cell for example 4557808818 the formula I'm tying to write is =if(left(a1,1=4),"airbill",if(left(a1,1=5),"online" etc. what is the correct format o write this so it reads the first digit f a string and categorize it? thanks