## Formulas Related Problems & Solutions

21 tags
Refine Tags

Results 1 - 21 of 21
[Solved] growth rate formulas, with a twist
Summary: Hi, So here's a tricky one. I tried using CAGR but it doesnt seem to work for me... maybe my logic is wrong. Here is what I want to do: 1 have 37 colu...

[Solved] formula help in excel
Summary: i have 36 columns with an increasing number in each cell left to right... i.e. range is A1 to AJ1 and the numbers start from 7 in A1 and go up to 286 ...

[Solved] Lookup a column, if matches, give me the last number...
Summary: Hi there, We are having a problem in our billing where we hire fleet to other departments, and the data entry person is sometimes not matching up the ...

[Solved] Days360 is bringing back negative numbers
Summary: Can someone look at this? IF(G14<>"",DAYS360(G14,E14),"") G14 is the assigned date while E14 is the date it was created so if it was created on 5/2...

[Solved] DEBUGGING: Nested drop down in an IF stmt using data validat
Summary: Hello! I'm trying to get the following formula to function.. and as it's setup the final [false] parameter keeps showing up, as IF it's ignoring the r...

[Solved] comparing to dates and times within a timeframe
Summary: Hello, First off I have no idea what i'm doing just want to make a large task seem a little smaller I have four columns with dates and times A2: Start...

I cannot copy and paste a formula in excel
Summary: I cannot paste a formula that I have copied. I copy the formula then try to paste it, and it just pastes the calulated amount from that cell. This fun...

Auto populate rows in Excel
Summary: I am using the forumla =IF(ISBLANK(Sheet1!A33),"",Sheet1!A33) to insert info from sheet 1 to sheet 2. The problem I'm having is if I delete a row on s...

Finding the time between two different times in excel issue
Summary: As an example I have 2 columns, A and B - both respectively titled Date and Time. In A2 I have: 4/03/2012 In A3 I have: 8/03/2012 In B2 I have: 20:34:...

[Solved] Changing worksheet name in formulas
Summary: If I rename a worksheet, will the new name automatically be updated in formulas and/or pivot tables that reference that worksheet? If not, is there a ...

if cell contains text from data validation, t
Summary: If a cell contains text from data validation that I created, how can i make a rule to what the adjacent cell will be? Example: If cell B57 has a lis...

Having problems w/Excel and negative time.
Summary: Using columns A - Name B - Time In (formatted to ex. 1:30 pm) C - Time Out (same as above) D - Break (entered as positive time, always .50) E - Total ...

Grouping rows on multiple criterias
Summary: Here's what my spreadsheet looks like: (A) Client Name (B) Date (C) Session Type (D) Formula (If) return Yes when date is in a rang...

Closest match to text string (text&values)
Summary: Hi, I have a column that have a number which I want to find the closest match to another column whic have text&values. Any suggestions, Thank you, ...

Can you stop formulas updating on a date?
Summary: I have a workbook that monitors year to date sales. I have to submit a monthly report to our head office, I have created a seperate workbook for this ...

VBA To Hide a Row based upon a formula result
Summary: Hello, I am looking for help to right a Macro that will look at a cell containing a formula to determine its result and hide the row if the result is...

multiple if formulas in one cell
Summary: Hi, Can anyone help me i'm trying do the following condition in one cell: In cell H2: If J2 = Area1, return a value of 14 If J2 = Area2, return a val...

Excel Formula to Find a Tab
Summary: I have an excel workbook with multiple worksheets. The first sheet is a summary page for a project. The information from the summary page is based o...

A formula in Excel that will input a value fr
Summary: Can anyone help me with a formula or a way around this: I have an Excel spread sheet and on sheet number one column A have a list of names with var...

Date results showing up as #s
Summary: I figured out how to construct a formula that would add 7 days to a date from a previous cell. I am simply using =B2+7. My problem is that the results...

Excel: Add Data Based On Month
Summary: I have the following formula im having trouble with Im hoping someone can help me out A B D ...

1