I need to create a formula for a cell that has multiple tests with individual TRUE for each test...
example Slope is 1, 2, or 3. Each Slope has a differnet degree.
I need a formula the inputs the degree for each slope depending on what slope is enterered in a sperate cell.
In other words, if Column a is 1 then column B in the chart is 4, and if its 2 then the degree is 7.4, and so on....
I need Cell B26 to have an if formula that says if Cell B25 is equal to 1, then value should be 4, but if B25 is equal to 2 then value should be 7.4 and so on..... Can someone help?
I have set up to import a data file. This file is not sorted in any order. It contains the following fields:
endpoint - user defined #
Bank Routing number
Bank name
Serial number - system assigned sequential #
Date
Time - stated in military time
# of items
# of batches
Amount
I need to look in the data for a specific endpoint and interrogate the time column to return the amount if it is either: 1) before 19:45, 2) between 19:45 and 22:45, or 3) after 22:45. I actually need the formula to interrogate any field for different criteria, but this is the first of many. Once I get over this hump, I should be able to translate the solution to the other formulas.
Thank you and my undying gratitude goes out to this forum. You have been a great resource!!
Hi there.
I have a profile of figures i.e.
25 0 45 89 0 6
What I want to do is insert a formula that will return a 1 in the cell under the 25 (I will then multiply it by a cost figure) and return a 0 in all other cases. Basically I have a cost that is paid when production starts and it is irrelevant if there is a break in the production.
I want to put the cost all the way across in case the profile changes so when production starts it triggers this cost.
Many thanks.
Ok this is somewhat tough, I consider myself to be handy with Excel and can't figure it out.
I have one sheet with 3 columns: Product name, raw material name, weight of raw material.
So in the first column you have the product listed several times for every raw material, then the weight of that raw material. I want to create another sheet with all the products as the header for the columns, and the raw materials on the side...I've done this but now I need a formula to populate this matrix with the weight values that correspond to the product and raw material.
I've tried a bunch of different 'if' / 'and' statements using array formulas. Pls help.
I have this troublesome formula I've been working on.
According to what I've read so far in this forum, this will be cakewalk for you guys to find out of (or at least so I hope.. :-)
I don't know much about Excel, and what I do know is just logic sense, and a bit of common math.
My problem is in a sheet I use for my personal economy. (I'm a neatfreak, and a nerd...)
The logic of my sheet is that I seperate the different type of monthly expenses, and sum them individually. The way I do this is that the A Column identyfies an expense (where 1 = rent, 2 = food, 3 = gas etc) while the C column is the expense itself, Example:
A B C
On account 500
1 rent -200
2 food -20
3 gas -10
2 food -10
Sum expenses -240
On account 260
I then use this formula to discern them:
{=ABS(SUM(IF(A$4:A$30=X;C$4:C$30;0)))}
where X is substituted for the number in the A column.
1 would give 200
2 would give 30
3 would give 10
This works swimmingly. The problem comes he
A B C
On account 500
1 rent -200
2 food -20
3 gas -10
2 food -10
4 to saving -100
Sum expenses -340
On account 160
As you see, what is going to my saving account is registered as an expence, which isn't right... (I want the sum expenses to still be 240) So I've tried to not have the "type 4" to be registered as an expense (but it still needs to be in there, to balance the account) So I made this formula for "Sum expenses":
{=SUM(C4:C30)+(IF(A$4:A$30=4;ABS(C$4:C$34);0))}
What this is supposed to do is to take the sum of the expenses, and add whatever is marked with 4 (that is -340+100=240). This doesn't work. I've tried changing it around a bit, and for some reason, the logical test in the IF part never gets "true", even though it "should" . If I simplify:
{=SUM(C4:C30)+(IF(A$4:A$30=4;5;7))}
The value of the cell will always end with a 7, never a 5, which it should if one of the A columns contained a 4.. (assuming, of course that the last digit of the original sum is 0, as in the examples...)
I probably fail to see some logic Excel finds obvious..
Any clue?
PS: I can upload a clean copy of the sheet, if the problem isn't understandable.. I am however using a non-english Excel, do the formulas translate to other versions?
Hi All!
Does anyone know a work-around for being able to insert rows/ columns and carry formulas over withou using arrays or tables? E.g.
A B C D E
1
2
3
4
5
If insert a rown and have formulas in the cells above, how can I have the formulas carry over?
The reason why I can't use array formulas etc. is that this will be going into Spreadsheet gear which doesn't handle them.
Thanks!!!
I must perform a "nested if" equation for class. I am atttempting to say if cell reference is 0-1.99 value is nominal
if cell reference is 2-9.99 value is moderate
if cell reference is 9.99 and greater, value is severe.
How? And can this function be perfomed in all versions of excel?
I'm looking to sum by category. The green represents what the totals should be, and the gray shows where the solution/formula should go. I tried nesting a sum function in an if statement, but it didn't work. Ignore the word total in gray I changed that after I made the screenshot.
B11= If A2=A11 then add B2, if not add 0
*then carry this equation down through the rest of the data
* there will be probably between 30-60 data points.
I appreciate any help
http://s278.photobucket.com/albums/k...ent=hkljhl.jpg
Could someone help me out if what I'm trying to do is even possible. I was thinking that using a logic function would solve my problem but maybe I need a more advance one. What I would like to do is to control the input in C1 by the options below:
If A1 = nothing and B1 = nothing, then C1 = nothing
If A1 = something and B1 = nothing, then C1 = no
If A1 = something and B1 = something, then C1 = yes
I don't have a situation where A1 = nothing and B1 = something
Thanks.
Is there a wizard in Excel 2007 that easily allows me to create multiple condition formulas.
I need to calculate a median of data in column C. Only when column D = condition 1 and column E = condition 2.
I thought there was a wizard that helped with this formula creation in Excel 2003? Is it in 2007 also
