Referencing 2 Outcomes From One Cell

Apr 20, 2007

Formula that if the cell (C1) looks up C5, and the range in C5 is 1-10000, I want C1 to show 10, or if C5 has less than 1, then I want C5 to show 0.

View 9 Replies


ADVERTISEMENT

Formula With 6 Outcomes To Return 4

Apr 5, 2009

if h5 = "Supply Only" or "Supply Only With IWA" then I5 should be "S/O" however if h5 = "Supply Only With Survey" or "Supply Only With Survey With IWA" then I5 should be "S/o & S"

h5 could also be "Supply & Fit" or "Supply & Fit With Iwa" which should return "S/F"

but if h5 = "Supply & Fit With Survey" or "Supply & Fit With Survey & IWA" then I5 should be "S/F & S"

View 3 Replies View Related

How To Use An IF Statement With Multiple Outcomes

Dec 7, 2009

I want to say, if B1 = A then the value is 10, if B1 = B then the value is 20, if C then the value is 30 and D the value is 40.

If there are two conditions then I know it would be =if(b1=A,10,0) but this is obviously a bit more complex.

View 6 Replies View Related

Nested If Statement With 2 Possible Outcomes And 2 Vlookups?

Oct 18, 2013

I have an If statement I am trying to get to work but not sure of the flow. Each part works seperately but not together. What I need is if column E is blank leave blank, if cell DI2 is Yes then use columns DJ to DP for the lookup if DI2 is No than use columns O to U for the lookup. The first 2 lines are the individual formulas that work independently. The 3rd was my last attempt at combining them.

=IF($E21="","",VLOOKUP($E21,$O$5:$U$476,2,FALSE))
=IF($DI$2="YES",VLOOKUP($E21,$DJ$5:$DP$366,2,FALSE))

[Code]....

View 2 Replies View Related

Conditional Formatting To Reflect 2 Outcomes?

Mar 3, 2014

I have a master worksheet with due dates for various forms to be completed. These forms are on separate worksheets within the workbook.

I'd like to highlight the master date entry in red if the form hasn't been completed by the due date, but also highlight in green when it has been done.

View 1 Replies View Related

Formula To Predict Trends / Outcomes?

May 2, 2014

I used three different dates. In which the outcomes were available. The first three sheets.

Is there a possiblity to use excel to calculate a future outcome of the next month(Sheet 4). The figures are in a way linear, because the previous months are in it.

So it's possible for the future outcome to go up or stay the same. It can't be less then previous months.

See attachments.

It's about a holiday (combinations) of arrangements. So it'll be influenced by the date (because of holliday plannings), finance etc etc. But the last factors/variables we will use and test in SPSS and other programs.

The question is more: Is there a program/formula in excel which will predict the outcome in the last sheet with maybe a factor of outliners (this coincendence of a better salary in some parts/or the date that people will book a holiday). And how the formula would be formulated in the last sheet?

View 2 Replies View Related

Simpler Way To Record The Outcomes Of Matches

Feb 9, 2009

I recently posted work of my attempts to create a league table, i feel i have probaly chosen the worst way to record the actual results of matches, causing the need for complicated formula which donkyoite has been very helpful in doing and i thank him, but i dont understand whats going on, was wondering if there was a simplier way?

View 10 Replies View Related

Multiple Outcomes From A Logical Formula

Sep 28, 2009

I am trying to get more than one outcome from a logical function in a single cell. I am teaching a class and i want this particular cell to add up all the points from tests and quizzes and then give me an outcome of a grade (A,B,C,D, or F) Right now i can only get the cell to give me an outcome of A or B. I need the cell to be able to give me 5 possible outcomes (A,B,C,D,F).

Right now i have this formula in this particular cell......=IF(Q6>234,"A")......so if Q6 is greater than 234pts they get an A...if not they get a B. How can i also give ranges of total points to have the cell give C,D, or F?

View 5 Replies View Related

Negative And Positive Outcomes In Worksheet

Apr 4, 2014

In my sheet i got some negative and positive numbers -210(Negative) and 210(positive).

So when on F there is a Negative number on K must come (Yes).

And when on F there is a positive number on K must come (NO)

It must go on for all on F

Is there function for that in Excel what i got now.

View 5 Replies View Related

Web Query Looping Multiple Outcomes

Dec 8, 2009

I have a web query that I would like to loop to a specified range. The catch is there are two possible outcomes. There is an outcome (data) and an outcome that is useless (no such page is found, etc). I'm kind of stuck trying to get this thing to loop. I would like to reference a range (contains links for input), and input all the data from the range, and based on the outcome, input the useful webpage data into the same spreadsheet.

Here is where I'm starting out.

View 9 Replies View Related

Compare The Number Value Of 3 Cells To 64 Possible Outcomes

Apr 16, 2007

I need to compare the number value of 3 cells to 64 possible outcomes, of the three cells they can only have one of four possible values, How do I write the formula to do this. if cell a1 is 1,a2 is 1, a3 is 1 then thave it display the number 64, but I also need it to able to look at the same three cells, 64 different combinations, like 0,0,1 displays 21 etc.

View 9 Replies View Related

Creating Outcomes For Normative Values Using Time Hh:mm:ss

Aug 6, 2014

I seem to struggle with excel formulas when time is involved. I am trying to create a spreadsheet that reviews outcome measures (walking tests in this case) to outline firstly if someone has improved or not (Outcome in the blue columns) which seems to be working alright. This takes into account the 2 aspects of time taken to complete the test and the walking aid required.

What I would now like to be able to do is compare each individuals 'After' score with a normal range for that test. I have put a list below the table of the ranges I am looking for. I have tried to put time formats into a long IF formula to try and get the ranges covered for the TUAG test, but doesn't seem to be working.

The 10 metre walk test is a little trickier as this is looking at change in velocity between the before and after scores. I think I need to be able to work out the velocity for each test and then do a comparison, but again bit stuck with the time formatting.

View 2 Replies View Related

Generating Random Outcomes Based On Probability

Feb 10, 2009

Can anyone help, I'm trying to create some test data, eg 1000 rows in excel. In each cell a formula (?) returns some text such as Dog, Cat or Rabbit based on the probability Dog=0.5, Cat=0.3, Rabbit=0.2

I've come up with a messy solution of generating a random number between 1-100 and then using a lookup table where 1-50 = dog etc... it works but is long winded and difficult for other people to follow.

View 6 Replies View Related

Count And Select Outcomes, Skip Duplicates

Oct 27, 2009

This code counts all cells with a value from column B1:B:10, C1:C10, D1:D10, E1:E10, F1:F10, G1:G10 and H1:H10. And then give the cells of the 3 lowest outcomes a blue backcolor. The problem is that the code also colors any duplicate outcomes. How can I let the code skip any following duplicate outcome(s)?

View 2 Replies View Related

Use Excel To Create A Formula To Predict Future Outcomes?

Jan 17, 2014

So I have some stats I have been tracking for NHL hockey games. I want to find a formula that is predictive of future outcomes, based on whether or not a team has a statistical advantage. Obviously, there are so many other factors, and there is no golden formula to accurately predict the winner of ever game. I want to find maybe a 70% success rate here. I want to be able to plug in all of the stats, and essentially have it tell me who statistically should win the game.

I have 11 independent variables (Stat A, B, C, D, E, etc.). I have a running total of how often the winning team had the stat advantage for each of these, and I think that should factor into the formula. My dependent variable is whether the team wins or not. how to do that with multiple independent variables.

View 3 Replies View Related

Excel 2010 :: Cell Summing Through Referencing Neighbor Cell Contents?

Feb 12, 2014

we have a Excel 2010 worksheet containing multiple tables.

Table1
ColumnA ColumnB
1 Blue 12
2 Orange 14
15
11
3 Red 10

Table2
ColumnA ColumnB
1 Blue 11
2 Black 13
15
11
3 White 10
19
17

On a separate worksheet we want to calculate with the first worksheet's values.

For example: Calc1: Sum ColumnB IN Table1 WHERE ColumnA = Orange

How do we do such a calculation/formula?

View 4 Replies View Related

Referencing A Cell By Tab Name

Feb 8, 2012

Here is a formula I am trying to use to access another woorksheet to compare the values in J13 in each worksheet.

=IF(J13=INDIRECT("'"&$O$4&"'!"&"J13"),"â–¬",(IF(INDIRECT("'"&$O$4&"'!"&"J13")=" ","â–¬",(IF(J13=" ","â–¬",(IF(J13>INDIRECT("'"&$O$4&"'!"&"J13"),"â–¼","â–²")))))))

Where O4 contains the name of the first worksheet.

I want the formula reference [J13] to chage to J14, J15 and so on.

View 3 Replies View Related

Referencing One Cell From Another

Nov 30, 2006

I'm dealing with a DDE link and have a cell that works when I type in the value =WINROS|AVEVOL!XOM . But I don't want to manually enter each value. So I have tried to use =INDIRECT("WINROS|AVEVOL!" & A2) where A2 contains the value 'XOM', but I get a #REF! error.

View 9 Replies View Related

Referencing Cell And Filtering Causes Cell Referenced To Change

Jul 10, 2014

Warhammer Quick Reference Desktop.xlsx

Its on book 2.

I'm trying to reference the Cryptek total that I got in the previous area, and put that result into the grand total army point formula. When I reference the solution cell, or even copy and paste the very same equation into it, and then proceed to filter the referenced cells change...

The obvious solution that i thought would work is write =D45 next to Cryptek in the point value column, then if I filter it SHOULD maintain the information from D45 except it doesn't.

View 11 Replies View Related

Blank Cell Referencing

Mar 2, 2009

On the spreadsheet Im creating I am using cell referencing. The user will input data into the blank cells, and cell referencing will put them into another table. Then I add these using an IF(OR(ISBLANK formula.

However, the empty cells come through as 0's rather than a blank cell. As they're coming through as 0's, they're being calculated into the formula, and this is causing problems in my main table.
Is there a formula I can use to ensure that the empty cells being copied over do not give off any other value?

I tried to use a few different IF formulas to only let specific data go through, but it didn't work. I tried to have the blank cells produce a letter so that they wouldn't be calculted in the formula, but letters are also counted as measured values.

View 14 Replies View Related

Referencing Last Cell >0 In Range

Jul 10, 2009

I have a row with month titles. I manually fill this with data as the year progresses. I need to automatically use the last month updated in the row in a formula. i.e. theformula is in one cell and calculates on the last figure in the row e,g, data is in january (say C3) - when I input Feb data in C4, I want the formula to automatically reference the last complete cell (ignore january data and calculate on Feb data), and so on through the year.

View 12 Replies View Related

Matching And Cell Referencing

Jun 17, 2009

I'm trying to grab data from two sheets by first doing a match. The match works, but how can I now reference ws2 so that I can pick up data if this match is true?

View 2 Replies View Related

Referencing A Cell Value In A String

Dec 14, 2009

I have a drop down list that references a few cells in another worksheet. When a value is chosen from the list, the adjacent cell give a description. Basically THe drop down is a list of clinic codes and the description gives time, day etc.

In order to do this, I have written modules as necessary for each drop down list like in the example below: .....

View 12 Replies View Related

Referencing To Cells Next To A Given Cell?

Nov 20, 2008

My current worksheet is being built for use in Eve-Online, a game I play. In specific, I am keeping track of profit made by manufacturing different items in the game. I am trying to build it like this:

Column 20 is a list of items, and the next 7 cells to the right of each item contain the mineral requirements for that item. So C20 says Bantam Frigate, C21-C28 will all contain numbers. Now, I am trying to create a function in the upper-right cells (like A1-A8) where if I type in "Bantam Frigate" into A1, A2-A8 will fetch the numbers that I put into C21-C28.


Now, I will be working with thousands of items, so I have to make sure I name both the 'database' and the query exactly right, but that's not a problem to me. Can I make something that will reference a value from (cell+1 column right) or (cell+2 columns right)

View 4 Replies View Related

Referencing Same Cell After Sorting.

Apr 16, 2009

Say cell A1 has 55
Cell B1 has the formula =A1

Sort only column A (the 55 now becomes in a different row)
Cell B1 chnages value because it is referencing cell A1 which has now a new value.

I want cell B1 to ALWAYS get the value from that orginal cell (i.e. 55) no mmatter where that cell gets located after sorting.

INDIRECT, and Nammed Ranges don't seem to do it.

View 8 Replies View Related

Referencing Cell Value In A Formula

Apr 16, 2013

Here is what I have

1. Have a COUNT value in a cell (counted the number of rows with values in them).
2. A formula that needs this value (sums another set of values in another column that has the same number of rows).

Example: the COUNT value is 12, and is located in cell G5.

For simplicity sake I have a formula in cell I5 SUM(F1:F12).

Instead of directly referencing F12, I want the formula to be SUM(F1:F(G5)).

View 5 Replies View Related

Referencing A Cell In A Worksheet.

Jul 25, 2006

I used to think I was moderately intelligent. Certainly, I thought I knew my way around a computer. Then I got the bright idea to try and learn VBA. Since then every attempt I've made in trying to produce the most basic of code results in mad fits of rage and me wanting to slit my wrists. I've read half a textbook and I keep trying to write simpler and simpler code to get some sort of result, just to give me the drive to carry on but no matter what I try it always goes completely wrong.
So before I stick me head through the computer screen, here is today's attempt. I want to select a worksheet. I then want to copy the contents of cell A2 down to A1200.

Private Sub CommandButton1_Click()
Sheets("Calls Outcome").Visible = True
Worksheets("Calls Outcome").Activate
Range("A2").Select
Selection.AutoFill Destination:=Range("A2:A1200")
End Sub

I’ve stepped through the code and I get an error on “Selection.AutoFill Destination:=Range("A2:A1200")”. After spending several eight-hour days trying to get something out of VBA I have zero energy and zero patience.

View 6 Replies View Related

Referencing The Value In A Cell For A Max Equation

May 20, 2007

I have a cell on ' Sheet 2' with the following formula:

=MAX('Sheet1'!C3:'Sheet1'C10)

ie. it chooses the maximum value from column C between rows 3 and 10 on "Sheet 1".

Lets say the cell reference C10 is now entered into cell B1 on Sheet 2. How do I modify the above formula to reference B1?

I have tried INDIRECT function but can't get it to work.

View 5 Replies View Related

Referencing A Cell Based On Position Of Another Cell

Jan 23, 2009

Right now cell B7 is referencing cell D3. However I want this to be dynamic in the sense that suppose I change the Phase 2 (which starts from ww3 (cell D3)) to ww5 (cell F3) then I would like that B7 should also get updated to F3 instead of D3.

Basically the Development phase of "Support" Project starts only when Phase 2 of "Project 1" starts.

ww = Work Week.

In short cell B7 should always be in sync with the ww of Phase 2 of Project 1.

View 3 Replies View Related

Referencing Cell Based Upon Data In Another Cell?

Feb 5, 2013

In cell H1, I want to multiply the value in cell B[x] by $G$1 where x is given in cell A1. For example, if A1 is 4, I want to to multiply B4 by $G$1 and have the result in H1.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved