Excel formula Related Problems & Solutions

104 tags
Refine Tags

Start a discussion

Results 1 - 30 of 104
[Solved] Excel formula to return number of days in a month?
Summary: I'd like to return the number of days in a month in column B, based on the date in column A. The problem is, column A does not have a specific date (0...

if two different cell colour same then condition should true
Summary: MY DOUBT PLS SOLVE if two different cell colour same then it condition should be true MY DOUBT PLS SOLVE if two different cell colour same then it con...

[Solved] How to put a comma between values from multi-formula string?
Summary: Hi, I'm using the following formula string: =IF(Recs!B2=TRUE, "Gas", "")&IF(Recs!C2=TRUE, "Electricity", "")&IF(Recs!D2=TRUE, "Water", "")&IF(Recs!E2...

[Solved] How to copy cell value from one workbook to another
Summary: Hello All! I'd really appreciate some help for a fellow Excel newbie! (pleeeeeease) I have Workbook1 with file names "SenFile" and durations "Slength"...

[Solved] Only count cells if the date is March?
Summary: I have a worksheet where I need a tally of who is doing what during a certain month. In this case, A is the date, B is the person, C-D-E are the types...

How to extract 1 date from a cell with multiple dates?
Summary: I have one cell with a date range and need to have each date be extracted to a different cell. message edited by sarahh770...

[Solved] If the date is 002/01/17, how can I make February show up?
Summary: the second part of this is if it's not February, I want it to say "Other". This is failing right now but it seems it should work.... =IF((TEXT(a2, "m...

[Solved] How can i edit characters within a string of characters?
Summary: I have two excel spreadsheet that I need to compare using vlookup, using case number to do so. The two sheets have case number stored differently, for...

[Solved] [EXCEL]Calculate account balance with intervals and interest
Summary: I'm trying to calculate an account balance after, say 10 years. I want the sheet to display balances with a given intervals, say an interval of two wh...

[Solved] Is there a way to simplify this excel formula?
Summary: I'm trying to process a couple of values in Excel, and came up with this formula, which works: =$A3*B3+$A4*B4+$A5*B5+$A6*B6+$A7*B7+$A8*B8+$A9*B9+$A10*...

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] How to add $ sign automatically in the formula in MS Excel
Summary: Hi, I have an excel worksheet containing column A to M with data from row 2 onwards. E.g. For row 2, value in M2=K2+L2 and row3, value in M3=$M$2 For...

[Solved] Change number in a formula buy referencing a different cell
Summary: Basically I have this formula: =(MIKE!$B8) and I have a bunch of cells withs Numbers like so: Cell | Cell Number Change C1 | 10 C2 | ...

[Solved] how to progressively calculate averages down an excel sheet
Summary: Excel formula to calculate a progressive average down a sheet a 5+5=10 b 7+7=14 average = 24/2 = 12 c 8+8=16 average = 40/3 =13.33333 d 9+9=18 averag...

Yes or No Decision Column
Summary: I need an excel formula to perform the following: I have 4 columns of activity. If there are any balances at all, I need the cell in a separate colum...

[Solved] How to access the responses
Summary: i am almost completely P.C. numpty. I have asked a question related to Excel formula and I am informed i have solutions but HOW do I view/access the ...

[Solved] Calculate Thanksgiving Day for the next 15 years using excel
Summary: Use Excel formula to calculate Thanksgiving Day 15 years in the future using the formulas Date & Time function. Or a better solution within excel ...

[Solved] I want to find the formula for salary tax calculation.
Summary: The salary has the following schedule If salary is up to 5000 its exempted from tax. If salary is up to 12500, so 12500-5000=7500. now 7500 is taxable...

[Solved] Excel formula visa pasport validity
Summary: Hi there, Is any one can help me find the formula the scenario is this, i had all the list of the employee 1 column is the name of the person, 2 col...

[Solved] Formula in excel Header
Summary: I want to add excel formula and picture link in excel header. I have person information in my first excel shhet of workbook like name, Bar code image,...

[Solved] Using a table to return lane rate
Summary: I have a table where going from one point to another will be charged a rate based on the beginning and destination points. YUM MOR 1.45 YUM SW 1.38 YU...

[Solved] Concatanate results into a single cell
Summary: I hope I used the right terminology for this, I don't think I've ever done anything like this before! I have a workbook that gives keeps track of all ...

[Solved] Excel Formula: Help with IF using current date
Summary: I am using a spreadsheet to track tasks and would like to automatically change the status of the task to "Due" when current date is 15 days from the t...

[Solved] Keep a running total of a growing spreadsheet
Summary: So....a friend has a spreadsheet that will be growing daily with new data and on one row, he'll have the totals of all calls that he wants to sum auto...

[Solved] Excel Formula Help: IF Statement With Percentages
Summary: IF $500*3% IS GREATER THAN $20, $20, IF $500*3% IS LESS THAN $20, 3% HOW DO I DO THE FORMULA TO ENTER THIS IN MY SPREADSHEET? A4 $500 B4 ...

[Solved] Excel Formula for identifyng when a , condition is match
Summary: Hi..!! I have a large table with specific number for each entry, as follow: Name Min Max TypeA TypeB TypeC TypeD TypeE Joe 124 ...

[Solved] changing an excel file from 00:00:00 to 0.0 but keeping the
Summary: changing an excel file from 00:00:00 to 0.0 but keeping the same values what excel formula do i use to change 00:00:00 into identical 0.0 format e.g....

[Solved] Need Excel formula To Return Value Based On Other Cells
Summary: Hello! I am trying to create a formula that will give me a resulting number depending on where it falls between three cells (with number values). 1)If...

[Solved] How do I get this IF statement to work?
Summary: Sorry if this is in the wrong place, I have no idea where to put it. Hey, I'm starting a little project that calculates the best possible build for a ...

Need help: IF statement with multiple conditions
Summary: If a2 is less than $65, 0 but if a2 is $65 to $69, $10 and if a2 is $70 to $74, $15, etc. How do I enter this in my excel spreadsheet? ...

1234


Ask Question