## Formula Related Problems & Solutions

301 tags
Refine Tags
Search Tags:

Results 1 - 30 of 301
[Solved] Excel to Access-disappearing numbers saved as text
Summary: To clarify, we have account numbers of 15 characters and when they come to us from other reports in Excel, they're sometimes saved as text. When we'v...

[Solved] Macro to insert a formula in a column
Summary: Hello, Me again. I've been struggling today trying to make a macro to insert an INDEX-MATCH formula in a column (since I can't seem to make it work ot...

[Solved] How do I: if X2 = A2, then change X2 to red?
Summary: How do I make a cell change color if its value equals that of another cell? Reason: If my "results" # matches my "uploaded" number, I want the "result...

Excel Formula to return cell value with matching text string
Summary: I am working on an excel formula that will return the value of the cell if the text string matches. the problem I am having is the blank cells where ...

[Solved] Excel formula parse error
Summary: Hello, Can someone please tell me why this is giving me a 'formula parse error'? =IF(ISBLANK(I6),ʺblankʺ,((((I6-I5)*2.3))+(((J6-J5)*0.26)))) Thanks....

Excel Formula needs to add Index to return cell information
Summary: Hello, Currently I am working with two tabs of data that do not have the same unique identifiers at the same time. I am using a series of functions ...

Alternative suggestions to this select case code?
Summary: Hello all I have a macro that copies all the sheets from two workbooks into a new workbook. That is all good and working. Each sheet contains x-number...

What formula to use to check current or previous owner?
Summary: Hello all I have some data that looks like the following: A B C D E F G 1 ID Name Date bought Date sold Numerator denominator Owner status 2 111 ...

[Solved] How to add workday when start date is weekend?
Summary: When my start date falls on a weekend, how can I make the following Monday my Day 0? Say start date is Feb 7 (Sat), and I need to add three workdays (...

excel formulas(sum,average etc) not working, always giving 0
Summary: if there is a space after your number, it will be considered text and not number and calculations are performed only on numbers, whether that be sum f...

[Solved] how to type this formula into excell

[Solved] Formula to give different number to different texts?
Summary: Hello all If I have a column with texts in them (some of them quite large and beyond 255 charaters) and some of those texts are identical. Is there an...

[Solved] I need to say if cell A2=yes,Then,cell A3=EDATE(A1,3)
Summary: so to be clear, I have a cell that says yes, or is blank. If it says yes, I need to calculate a date 3 months ahead ...

How to create an if statement for a validation list?
Summary: I have a spreadsheet that tracks students. On sheet 1 is the complete of students. On sheet 2 is a report. I need a formula for a dropdown that will l...

[Solved] why am i getting one answer on a calc and a diff on excel
Summary: ok my problem is when I do my equation with my data on a calculator example 1666.67*90%=1500.003 but if i do the formula =IF(AND(\$B\$59<100%...

[Solved] How to write a formula with IF and vlookup
Summary: How to write a formula with IFERROR and vlookup, when the data to be looked up are in a separate sheet within the same file? Thanks for teaching me. ...

[Solved] IF formula using data from several cells
Summary: I cannot figure out the formula for: If cells B2:34 contains a match of data in cell B37, then I need cell K37 to track costs specified in cells J2:J...

[Solved] help with excel formuals
Summary: How get a cell to work out a cell to calculate 2 formula Ie If G3<= 50 and D3<= 10 give an answer of 5 if true and 10 if false Thanks ...

[Solved] Convert Number Of Month To Name Of Month
Summary: hi guys =TEXT(DATE(2000,A1,1),"mmm") that formula is correct but most of the time year is different when we analyses 2 years data, hence we not change...

[Solved] How to change a lot of cells to absolute (macro fails?)
Summary: Hello all Ive been using this macro a lot of times, but I am running into some strange problems with it. Sub Absolute() Dim Cell As Range For Each C...

[Solved] Excel - Need To Calculate Days And Hours Between Two Dates
Summary: CORRECTION TO ORIGINAL CLOSED THREAD Excel - Need To Calculate Days And Hours Between Two Dates ORIGINAL THREAD http://www.computing.net/answers/of......

[Solved] Add Formula after the Last used Cell in a Row
Summary: Hi, I am looking to add various formulas in the last column of a row. The code is below what I am Iooking to do is replace column "F" with the last c...

[Solved] Formula is returning the text format instead of date format
Summary: I am working on creating a identifier for my data but when I enter in the formula into Excel 2010, the results are not appearing as I expected. Here i...

A Small Glich in the VBA code to Hide the formula cells.
Summary: Hi! I have used the VBA code from the site you mentioned http://www.ozgrid.com/VBA/stop-form... It works fine.. But as soon as i select a range of cel...

help with excle formula
Summary: 3 columns column 1 = a £0.00 Column 2 = enter a letter - excel recognises the letter and transfers to column 3 Column 3 = £0.00 if letter in column...

[Solved] How do i get Max value from the Sum of 2 cells as below
Summary: A B 1 2 3 4 5 6 The values above represent 1 & 2 in cells A1:B1, 3 & 4 in cells A2:B2, 5 & 6 in cells A3:B3. I"m looking for the Maximum ...

Caluculating a value based on a range
Summary: How do I enter a formula that provides the following answer; If a cell value is between two amounts I want to show a different answer. EG: totals sale...

[Solved] Why does the following function return #VALUE!
Summary: Cells (A,B),(C,D),(E,F) & (G,H) ARE MERGED TO FORM 4 CELLS. This Function is designed to give me the result of the last cell in the row that contains ...

[Solved] Using NETWORKDAYS() with MOD() for difference between 2 days
Summary: The entries are as follows 13.06.2014 23:59:59 30.04.2014 16:36:29 08.05.2014 15:11:49 12.05.2014 22:30:05 etc., etc., Now after using the formula...

[Solved] I desire help with a formula
Summary: I have resolved how to add Numbers in a given column for 2 or more linked work sheets. EXAMPLE; =SUM(SHEET1!F:F,SHEET2!F:F) I can also add NAMES or...

123456789... ⇓»

Popular Tags