Over 1 million tech questions and answers.

Excel 2013 - how to keep a formula consisten

Q: Excel 2013 - how to keep a formula consisten

Hi

I am trying to tie one cell into a formula that is being pasted into multiple rows.
I know you can use $ to keep the cell consistent but it doesn't seem to be working.

So if the value is in c9 and then first row gets c9 then the new row gets c10 etc... I need it to be c9 throughout the column.

RELEVANCY SCORE 200
Preferred Solution: Excel 2013 - how to keep a formula consisten

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Excel 2013 - how to keep a formula consisten

You use $C9 to keep the column consistent, C$9 to keep the row consistent and $C$9 to keep the cell consistent. Are you doing that and it's not working?

Read other 2 answers
RELEVANCY SCORE 60.8

For some reason I cannot get Excel 2000 to display the results of a formula. Only the formula text displays. I've gone to Tools-Options-View-Windows Options and checked and unchecked the Formulas checkbox. It doesn't make any difference.

Help!

Thanks,

Thomas
 

A:Excel 2000 Formula Text Displays instead of Formula Results

Format the cell as a number, it prolly is fmt'd as text
 

Read other 3 answers
RELEVANCY SCORE 60

Hi ~

I'm working on a financial formula, trying to calculate a growth rate for a row of cells. The problem is that not all rows have complete data sets, so the formula picks up blank cells and returns a #DIV/0! error.

The existing formula works fine for those rows that have non-zero entries in all cells, and I *can* manually adjust the formula for the starting / ending cells in each row--but what a pain(!). As this spreadsheet grows larger, or the data sets change over time, it means I have to constantly keep adjusting it for every row of data involved, which is extremely time-consuming.

Here's an short example of what I might have in any given row:

A1 (blank), B1(blank), C1(blank), D1(.10), E1(.25), F1(.72), G1(1.0), H1(.80), I1(.60), J1(.75)--then in K1 is the growth formula, e.g. =((J1/A1)^(1/10)-1).

Is there ANY way to create a formula that will dynamically adjust for the blank cells that might exist across a row of data and let the formula do the calculation?

I'm new to advanced Excel topics, but any ideas would be MOST appreciated(!).

Thanks -

CP
 

A:Excel Formula / How Can I Ignore Blank Cells In Row Formula?

Read other 14 answers
RELEVANCY SCORE 58.8

Hi, I need to do the following:

Search array
1 a 12 asdas
2 b 121 agrsfsa
3 c 3 qwgds
4 b 131 erwer
5 e 4123 q3eqt

need to return something like this
lookup value b

answer should look like this

2 b 121 agrsfsa
4 b 131 erwer

index, match can give me one row, however what could return multiple values

Thanks in advance for your help.
Cheers
 

A:Excel: Is there any formula that would do Autofilter's functionality as a formula

Read other 8 answers
RELEVANCY SCORE 58.8

If it's possible to do this, what is the formula syntax for an if/then formula in one sheet that refers to the cell value in another sheet in the same workbook?
For example in Sheet 2, the formula would be something like, if Cell A10 in Sheet 1 is greater than 0, then the value of Cell B20 in Sheet 2 would by "Yes" but it would be "No" if the valuein Cell A10 in Sheet 1 was less than 0.
 

A:Excel formula using formula between sheets in workbook

Read other 6 answers
RELEVANCY SCORE 56.8

I have created a formula in Excel that works fine, but when I put it into a MS Word table, it doesn't seem to work. The formula adds up a column of prices when the resulting column has a specific word in.

The formula is:
=SUMIF(E:E, "Yes", D:D)

Example:


Is this possible to do? If so can anyone help converting this so it will work in MS Word.

Thanks, Adam.

A:Excel Formula to Word Formula

You'll have to do this:

https://support.office.com/en-us/art...4-0d7e88062257

Read other 2 answers
RELEVANCY SCORE 54

I cannot search for data in excel 2013. This is new issue. I do notice that in the find window there is an entry for Preview* in the box next to format in the options window that I have never seen before. I get the message cannot find what you are looking for but I know it is there because I am looking at it.

This is new issue. Worked until last night when I was doing a sort and had to make all merged cells uniform in size. Now I can sort but cannot find.

Have closed and reopened excel, but it did not correct problem.
 

A:Solved: Excel search does not work Excel 2013

Read other 7 answers
RELEVANCY SCORE 54

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

Read other 1 answers
RELEVANCY SCORE 50

Question:
If I am trying to add 3 cells and not all 3 cells always contain values. I have formulas in them and if the cell is empty then the #N/A comes up in the cell. So when I have the @sum in another cell to add them it doesn't compute.

Example:
A1 - 5
B1 - #N/A
C1 - 5

I want a formula to add these 3 cells up even when one of them is N/A ??????
 

A:Excel Formula

You should use the IF statement to set the cells to do the function, or set it as a blank value if no numbers are present.

Post the formula you have in the cells that make them show NA.
 

Read other 3 answers
RELEVANCY SCORE 50

History:
I have two excel sheets, 1) breaks 2) jobs for the day.

In the breaks sheet i have time listed down a5:a50 each cell represents 5 mins. within this sheet on b20:b:24 i have a 20min merged cells break.

On the second excel sheet i have the same time list from the
=now() in a1, showing the time down the page. Again i have sectioned each job in to time periods of merge cells. ie 10min = 2 merged cells, cleaning.

What i want to be able to do is create a formula that will look at the time from the sheet two, (jobs) copy that days jobs to the first sheet, Breaks, find the time and fill down, missing the breaks out and copy below the breaks for the period in time.

I know its a lot.

But if you can Help!!!!
 

A:Help with a excel formula

Would defining rangenames help point to the areas on your second sheet (jobs), then developing a macro to do the math, copy, paste, etc?
 

Read other 2 answers
RELEVANCY SCORE 50

I am doing a spreadsheet for a volunteer fire department and we want to be able to keep track of the percentage of meetings, drills, and fire calls each person attends. I thought I had it right but I guess not now. I've included what I have done so far.
My problem is I don't know how many members there is at the time so I just created enough for 47 members to be tracked (I'm sure it's less than that). I realize I have an error formula but after input is placed in cell it disapears. I do not want that error to show up if I haven't filled the cell (I don't want error printing out on sheet if there is no member listed for that row).
Also I would like someone to verify that I did things right at the bottom... Where I have Department Averages.
This is like my first spreadsheet I've done so be easy on me. Trial and error. Any suggestions would be appricated.
Thanks in advance,
Art
 

A:Excel formula help please...

Filter the divisor with an IF function,

=IF(B6="","",C6/B6)
 

Read other 3 answers
RELEVANCY SCORE 50

dear friends
is there any formula who prints the exect sheet name
eg.
in my excel workbook the 1st sheet name is "sample" so i want to use a formula who shows the sheet name as it is
 

A:Excel formula

Read other 8 answers
RELEVANCY SCORE 50

Hi All,

I have a spreadsheet attached that lists revenue and target by month for each name. I need to make a ytd formula that can calculate this. I cannot move the columns of the data around, so they have to stay in this format. Can anyone help?

Thank you!
Winnie
 

A:ytd formula excel

=SUM(B2,D2,F2,H2,J2,L2,N2,P2,R2,T2,V2,X2)
and then copy across to cell aa

then select those two cells and copy down

or am i missing something else you need
 

Read other 1 answers
RELEVANCY SCORE 50

Hi,

Does anyone know how to formulate the following:

X figure multiplied by .105, then that sum issubtracted from origianl X figure

Is this possible?

Thanks
 

A:What is the formula for Excel

Welcome to TSG!

=SUM(A1-(A1*0.105))

paste this function in cell B1 when the number you will input is in cell A1

You can then copy cell B1 and paste the function in B2-B??) and the values will change correspondingly to
=SUM(A2-(A2*0.105))
=SUM(A3-(A3*0.105))
etc
 

Read other 2 answers
RELEVANCY SCORE 50

I'd like to create a formula (some kind of IF statement) to test a range of cells to determine if any hidden rows contain values. The statement could return a statement like "Alert - hidden values" if it returns true.

We have a billing sheet, and some of the users tend to hide rows that don't apply, forgetting to clear the values first. Then, the total does not appear to calculate correctly.

Any ideas? I know how to do the if statement, I just don't know how to test the range of cells in a formula. Thanks.
 

A:Excel Formula

Read other 10 answers
RELEVANCY SCORE 50

What I want to do is count columns that contain text entries, and do a running total,so if i have a 100 names or any text in the columns it will count them for me, if i add or delete an entry it will adjust the figures accordingly
Thanks

Rama
 

A:Help with excel formula

Read other 7 answers
RELEVANCY SCORE 50

Hi there: What I am trying to do is set up an invoice. The invoice is complete and works well but I want to add a formula to calculate shipping and handling charges depending on the cost of the merchandise. There are 7 different levels for the charges depending on the cost. I have used nesting and it seems that I am only getting the first level charge no matter what the cost of the merchandise is. Are there any Excel experts out there who wouldn't mind giving me a hand? It would be greatly appreciated.

Thanks in heaps in advance.
 

A:Excel formula help, if possible?

Read other 13 answers
RELEVANCY SCORE 50

Hello,

I was wondering if one of you Excel Gurus Could help me

I have tried some different formulas with the "if" command and what not but am Unable to do this. Basically when I copy a bunch of Asset tags into one Column (eg. G) I need to automatically filter the Desktops into another Column (eg. H). If any of the Numbers match the numbers in column G match any of the numbers in column A then have the filter remove the Numbers. Whatever is left put in Column H.

I know this is possible

I hope that is understandable

I have attached the Excel sheet in a zip file

Thanks in advance

Tim
 

A:Excel Formula

Read other 15 answers
RELEVANCY SCORE 50

I'm creating an attendance tracker for my employer. Row A is the date of occurrence (i.e. employee was late/absent), Row B is the value of the attendance issue (1 for being absent, 0.5 for being late/leaving early), Row C is running total, Row D is the date the value is to drop off (6 months after receiving). I'm trying to create a formula so that when today's date is equal to or after the drop date in Row D, the value in row B will automatically drop off in row C. Does anyone know how to do that?

Thanks!
 

A:Excel Formula

Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

An IF in column B may work
if C2 date is =or greater than date(Year(today()), Month(today())-6,day(today())
then , start sum again
 

Read other 1 answers
RELEVANCY SCORE 50

I have a column with the following data examples in it:

8
HQ2394
HL3
H
CDHLQKN3428
HQ234
CDNQ3589
HLQKN342
HQKN342
HKLQ234
HQ28
HL
H8
D98
CDQKN3429
LQKN34289
3
3
3
3
DQKN3429L
KN34
LQKN34289
LKN348AU167RWX
L
L
L
L
L
AU16RWXKNO34
AU16RWXKNO34

What kind of formula can be written so that I can identify any cell with an L, or a 7 , or a 8 in it whether they are the only character in a cell or within a set of characters?
 

A:Excel formula

Read other 6 answers
RELEVANCY SCORE 50

Hello,

I am struggling to find a formula that will do the following:

Sheet 1 lists all of the schools in my school district, with multiple columns. For example,
A2 = Central Elementary
B2 = # Tested Math
C2 = # Passed Math
D2 = % Passed Math
E2 = # Tested Reading
Etc.

Sheet 2 lists some of the schools with data for Math
A2 = Central Elementary
B2 = # Tested
etc

Sheet 3 lists some of the schools with data for Reading

I need a formula that will look for "Central Elementary" in Sheet 2 and then the corresponding data for that school. I can't do a simple copy and paste because not every school is listed in sheets 2 & 3, but all schools are listed on sheet 1.

So, my formula needs to look for Central Elementary in Sheet 2 and then the data from that sheet.

Hope this makes sense.

Thanks!
 

A:Excel Formula Help

Read other 6 answers
RELEVANCY SCORE 50

I attached a picture of the spreadsheet/current formula. I would like to add another formula into cell K101 so that when a value is entered into M101, K101 goes to 0.
 

Read other answers
RELEVANCY SCORE 50

I'm rustier than I thought with Excel, so here goes:

I'm creating a sales report spreadsheet. Cell C2 will be the invoiced amount. Cell Q2 is the sales rep's ID. Cell R2 is the commission (C2*.2) for the rep. Cell U2 is the company net (invoice minus commission). If there is a sales rep assigned to the client, how can a value in Q2 be worked into a formula so that if there is a rep their commission will show in R2 and the company's net in U2, but if there is no rep, there will be "zero" in R2 and the full invoice amount in U2? Must there be a number value in Q2, or will any data in Q2 work?

It should be an "IF-THEN" situation, but I'm obviously missing on the fine points of creating this formula.

I hope that I've made myself clear. Thanks.
 

A:Need an Excel Formula

Read other 6 answers
RELEVANCY SCORE 50

Can someone tell me how to copy a formula into cells below without changing the formula to refer to the cells it is being copied to. For example. If I have a fromula in cell B2 that says B2*D2 and I want it to stay that way how can I prevent it from changing when it is copied into cells below. I want it to say B2*D2 all the way down. Thank you
 

A:Excel Formula

=$B$2*$D$2
For instance, if you want to multiply all of the cells by a number in cell H1, you do this:

=A1*$H$1

Put the dollar sign in front of only the portion(s) you want to have *stuck*.
 

Read other 3 answers
RELEVANCY SCORE 50

Need help with a GOTO formula... I am trying to do an IF statement that will then goto a particular cell. I.e. IF a1 = checking, then GOTO e1, IF a1=savings, then GOTO e5

If anyone could help with this it would be greatly appreciated.
 

A:Excel Formula Help

Read other 13 answers
RELEVANCY SCORE 50

Hi,

Can someone please tell me how this formula works:

{=SUM(($F$74:$F$123)*($M$74:$M$123>=G135)*($W$74:$W$123>=G135))/4*(1+Data!$AI$23)^(G135/4)}

All the data is numerical and the result that I get from the formula is simply ($F$74:$F$123)/4.

Thanks.
 

A:Excel formula

First, you should be getting a numerical result, so click in the cell, go to Format, Cell and select General. Other formats may work, but apply them later.
Next, the {} means this is an array formula (some people call them CSE formulas - you will see why soon). You don't type the {} in yourself - you type in the formula and hold down Control, Shift and hit Enter (hence CSE) and Excel adds the brackets automatically.
Next, you have several ranges, such as $F$74:$F$123. Just for clarity, I will point out that the range could be written as F74:F123 but that would be a relative range - if you copied the formula and pasted it elsewhere, Excel would alter the range to match. Having the $ in the formula makes these absolute values, so no matter where the formula is pasted, the range looked at is always this one (or, rather, these ranges.)
Your formula does several things, so let me break them up.
{=SUM(($F$74:$F$123)*($M$74:$M$123>=G135)*($W$74:$W$123>=G135))/4*(1+Data!$AI$23)^(G135/4)}
Any portion like
=SUM($F$74:$F$75)>=G135 (also an array formula)
looks at the sum in the range to see if it is greater or equal to the value in G135. (If it isn't (in any of the comparisons) you get a value of 0.)
The next batch is more of the same - just algebra.
Finally, (1+Data!$AI$23)^(G135/4) takes the value on the sheet called Data in cell A23, adds 1 to it and raises the whole thing to the value of whatever is in cell after dividing that value by 4 (e.g., if the value in Da... Read more

Read other 3 answers
RELEVANCY SCORE 50

I hope you can help me with a fairly simple formula, but if formulas are really hard for me.
I want to put the work PAID in Cell b if Cell c has a date in it, otherwise I want it blank. Thanks in advance for your help.
 

A:Excel Formula Help

Read other 6 answers
RELEVANCY SCORE 50

Need help with a formula in excel.

I want to be able to calculate surface area, say of a box, by inputting the volume of the box.

I can do it on a calculator, but I don't think excel supports the cube root function.

can anyone help???
 

A:Excel Formula

Welcome to TSG, Starfish

Cube rooting, although not directly supported, can be done using the POWER formula

=POWER(A1,1/3) (where A1 is the number to be cube rooted)
 

Read other 1 answers
RELEVANCY SCORE 50

I am trying to find the formula to total up a sum between certain dates.

for example

In column A i have the dates
In column B i have the amounts paid in

I need to be able to click into a cell and use a formula to calculate the total amount in column B between certain dates in Column A.

EG: the amount paid in between 01/10/2007 and including 30/09/2008

i have tried the following but no sum comes out, =SUMIF(A:A,">01/10/2007and<30/09/2008",B:B)

Please Please can anyone help

Kaly
 

A:Excel Formula

I am not a very experienced Excel persion but I believe the problem is that the "criteria" argument used in the SumIF function is unable to combine logical expressions like you are trying to do:

Can Do ">6/30/2007" and can do "<11/1/2007"

But Can't do ">6/30/2007 AND <11/1/2007" at the same time

For you particular problem there still is a solution that uses the SumIf function

Add up ALL of the payments and then, using SumIf, subtract off those that fall before the start date and those that fall after then ending date

So to add all the payments between (including) June 1 '07 and Sept 30 '07:
Good:
=sum(B1:Bn) - sumif(A1:An,"<6/1/2007",B1:Bn) - sumif (A1:An,">9/30/2007",B1:Bn)

Now if you think about this approach you see that it isn't really necessary to sum all the payments and subtract off both ends, you only need to sum all the payments that fall on or after the start date and then subtract off those that fall after the end date.

Better:
=sumif(A1:An,">5/31/2007",B1:Bn) - sumif (A1:An,">9/30/2007",B1Bn)
 

Read other 1 answers
RELEVANCY SCORE 50

I currently have a formula that takes the current day, and compares to an Order Picked date.

The formula calculates is the difference between the dates is more than 2.5, "Overdue" is returned in the cell

The problem I encounter is on Mondays and Tuesdays, where I need to change the formula manually to 4.5 and 3.5
because the Sat and Sunday are not skipped and no orders are sent as those are off days. So an order picked on Friday
would show as Overdue on Monday as it is more than 2.5 days.

Original Formula : =IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))

The new Formula: =IF(AND($D$3=”Monday”,A2+4.5<$C$3),”Overdue”, IF(AND($D$3=”Tuesday”,A2+3.5<$C$3),”Overdue”, IF((A2+2.5)<$C$3,"Overdue",IF((A2)>$C$3,"Future",""))))

has not worked. Perhaps wrongly positioned parenthesis? It returns #NAME#

A sample spreadsheet is attached.
 

A:Excel IF AND formula and more

Read other 16 answers
RELEVANCY SCORE 50

I need help with an Excel Formula. I am creating a gradebook using points and not values for grades. For examples, E5:BE5 represents the total points possible for each assignment, E6:BE6 represents the actual points received, and E7:BE7 represents attendance. BD7 will sum E5:BE5, BC7 will sum E6:BE6, and BC6 will give the percent grade. My problem is when a new student comes in during the middle of marking period, I only want to add the total points from the point when he/ she entered. In other words, in E7:BE7 (attendance line) I want to put an "n" for new and in BD7 I wantto have a formula that states "if there is an "n" in E7:BE7 to sum only the cells of E5:BE5 that are after the column that "n" is in". Is this possible?
 

A:EXCEL formula

lbkubic said:



I need help with an Excel Formula. I am creating a gradebook using points and not values for grades. For examples, E5:BE5 represents the total points possible for each assignment, E6:BE6 represents the actual points received, and E7:BE7 represents attendance.Click to expand...

just to be sure what you're saying; Cell E5:BE5 contains the value of maximum points and the student score is in cell E6:BE6.
 

Read other 8 answers
RELEVANCY SCORE 50

I am sure this is simply enough to do but I'm just not up to speed with excel, I am producing a simple series of spreadsheets for someone to use as a register of people attending class. So far I have 12 sheets, one per month, and on each I have the list of names and the dates they have attended. At the end of the spreadsheet I have a total for the month and also a year to date total.
What I want to know is how to I transfer the year to date total to the next spreadsheet so that by the end of the year they have the toatal for the year.
Many thanks in advance.
 

A:Formula in Excel

A1 (January), A2 (Feb), etc - A13 (total) = A1+A2+ etc
 

Read other 4 answers
RELEVANCY SCORE 50

I have a spreadsheet which has results in columns.

Column A has the name of runners in the event, column B has where they finished (WON, 2nd, 3rd, etc). In column X I want to list the winner of the event for all runners except the winner.

Is there a formula that will do this for me.

The formula would need to be something like:

If column B =WON, then leave column X blank, if column B=(anything other than WON) find next record above where column B=WON and paste column A of that record into column X of this record.

I know that is not very well explained, but i have lots of records of races usually with 8 runners in each and against all that didnt win, I want to put the winners name in column X.
 

A:help with excel formula PLEASE

Read other 14 answers
RELEVANCY SCORE 50

Please help!!!!!!!!!!!!!!
A question that have puzzeled me!
excel the total is 55,250.00 and its asking for me to turn this amount for the month of October to a formula equaling 10%.
Can anyone-someone answer this for soonnnnnnnnnnnnnnn.
 

A:excel formula ?

Read other 7 answers
RELEVANCY SCORE 50

I need some help with an If statement that has multiple conditions and uses VLOOKUP. Here is the current statement that works, but is only for 1 condition:

=IF(D6="Grand Total","",VLOOKUP(D6,Data!$1:$350,2,FALSE))

I need it to not only test D6 for "Grand Total", but also for "". So, it needs to go something like the below, which doesn't work:

=IF(D6="Grand Total" OR "","",VLOOKUP(D6,Data!$1:$350,2,FALSE))

Thanks in advance for taking the time to help.
 

A:Help with Excel Formula

=IF(OR(D6="Grand Total",D6=""),"",VLOOKUP(D6,Data!$1:$350,2,FALSE))

Try this
 

Read other 2 answers
RELEVANCY SCORE 50

I need to enter this formula into excel:

=NETWORKINGDAYS(12-1-02, 11-1-22, July 4)

The start date is 12-1-02
The end date is 11-1-22
..and the vacation date is July 4th of every year.

How do I enter just July 4th so it does not count the year?
 

A:Help with Excel formula...

Looks like you can't:

http://www.uncc.edu/sysdev/HowTos/Excel/networkdays.htm
 

Read other 3 answers
RELEVANCY SCORE 50

I am needing help with a formula

Formula is for cell d1

IF C1 IS BLANK
THEN LEAVE BLANK
IF C1 IS 0 OR GREATER THAN 0 THEN
B1-C1

Thanks for any help I can get.
 

A:Excel Formula

Will C1 ever be less than zero? If not, this should work as the formula for d1.

=if(c1="","",b1-c1)
It looks at c1 and if c1 is blank, then return blank, otherwise return b1-c1.

Hope that helps.
 

Read other 3 answers
RELEVANCY SCORE 50

I have a sheet that contains a list of numbers for each hour of each day, monday through sunday 1 to 24. I need a formula to calculate the average of those numbers for the full week and then I need to make a chart with those averages. Can anybody help?
 

A:excel formula

How is your spreadsheet set out?

There is a simple average formula - but it all depends on the data it is looking at
 

Read other 2 answers
RELEVANCY SCORE 50

Ok so I have my products in column B. In column H I have the price of each product. In column P, I want to be able to assign a value to each thing in column B and then add the total per month.

Product Month Price Total Product Sales by Month
Router JAN 899
Monitor JAN 219
Monitor JAN 219
Switch FEB 699

Etc.....Is there a formula for this?

Read other answers
RELEVANCY SCORE 50

All;

I'm working on a Excel template that was created by someone how left there is a formula that I'm haveing problmes identifying where the file is beening saved. Here is the formula: =IF(default_dir_admin="","",default_dir_admin) Basically I just what to allow users of the template to click on the save button and the file will save to the location in the default directory. Any help would be appreciated.
 

A:Help With EXCEL Formula

Hello there, welcome!

Some questions arise here. Is this an actual template file (.xlt)? If you only want the file saved to a specific directory, I suggest using an event trapping (before_save) to control it manually. This means some VBA.

Is that about what you were thinking?
 

Read other 3 answers
RELEVANCY SCORE 50

I am running excel 2000 and I need a formula to do what I am fixing to put in if it is possible if it isn't please let me know.
if column c equals the word expense then add column D to Column E and total it below the last row on E if column C equals the word Income then add column D to Column F and total it in the following row of column F
if you can help me with this I would appreciate it ASAP thank you!
 

A:need an excel formula

Will the attached file work for you? It is set to allow up to 30 entries but can easily extended by copying the formulas into additional rows.
 

Read other 3 answers
RELEVANCY SCORE 50

Hi,

I want to be able to get excel to return a total based on adjacent cells with the returned formula being the lowest number in the other cells.

i.e. cell A1 will display the lowest number of cells A2 to A20 which will all have different numbers

Is this possible? If so can someone give me the formula

thanks in advance

Lee_1133
 

A:Excel Formula help

Read other 12 answers
RELEVANCY SCORE 50

Hi,

I have a table of text values, case sensitive and I tried using COUNTIF() to count the number of occurrences of a particular pair of letters, like so:

BB:RR
BB:Rr
BB:rr
Bb:RR
Bb:Rr

etc....

I did COUNTIF(Range,"*BB*"), but I found it's not case sensitive, and it's counting BB and bb as well. Is there any way to make it case sensitive?

Rgds,
 

A:Excel Formula Help

Read other 11 answers
RELEVANCY SCORE 50

Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: AMD E-300 APU with Radeon(tm) HD Graphics, AMD64 Family 20 Model 2 Stepping 0
Processor Count: 2
RAM: 3682 Mb
Graphics Card: AMD Radeon HD 6310 Graphics, 384 Mb
Hard Drives: C: 273 GB (183 GB Free); D: 23 GB (2 GB Free);
Motherboard: Hewlett-Packard, 188B
Antivirus: Windows Defender, Disabled

Hey Folks, it has been about 20 years since I wrote formulas in excel and I just do not remember.
Wanting to set up a formula so that the sum of column G cells are always equal to 1000. I need to subtract the value of the corresponding cell in column E. For example if E45 equals 500 cell G45 needs to equal 1000. Greatly appreciate helping an OLD user.
 

A:Excel Formula Help

not sure i understand
column g always = 1000
why sum
can you
Please upload a small clean sample of your data / workbook (not a picture) to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
We would like to see an example of your data and also a manual mock up of the expected results you want to achieve.
 

Read other 1 answers
RELEVANCY SCORE 50

Currently increasing a field (AJ2) based on certain criteria (If the designated cells (C5:C20 has and "X" in any of the column cells) (AJ2) would increase by (1) Now need to expand that criteria to include some additional entries as indicated at the bottom but exclude an entry of "N/C".

Current senerio;
AJ2 =SUMPRODUCT((MOD(COLUMN(C38:AZ38),2)=1)*C38:AZ38)

C38 =SUMPRODUCT((C3<>"")*(COUNTIF(C5:C20,"X")>0))

Need to expand the "X" in range C5:C20 to not be limited to just "X" but be expanded to include one of 10 specific text inputs like AWL, E/P, E/V or (7 other selected text inputs)

Thank you in advance
Winger
 

A:Excel Formula

Winger, I cannot for the life of me work out ½ of what you're trying to do here. For instance, COLUMN(C38:AZ38) just gives you the column # for C:C, ie: 3.

This is a complete stab in the dark, but how about if you amended to something like

COUNTIF(C5:C20,{"X","Y","Z"})

?

HTH,
Andy
 

Read other 2 answers
RELEVANCY SCORE 50

I need a spreadsheet formula that will reference an alternate numerical number in a sum function. I have a column of Priority values 1-22 and I want to assign a reverse value to each priority (i.e. 1=22, 2=21, 3=20, etc.) then I want to post the sum of the values incurred and not the sum of the numerical priority values in the cell at the bottom of the column. Should I be using LOOKUP in conjunction with SUM or SUMIF? Any ideas?
 

A:Need Excel Sum Formula

Read other 10 answers