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


ADVERTISEMENT

Compare A Cell With A Number Of Other Cells

Jan 13, 2009

I want to compare a cell with a number of other cells to check if their value is the same. If it is the same an IF function will perform some action.

For example I want to check if A23 is equal to B23,B24,B25.....B50

Something like IF (A23= B23 to B50,"hi","bye")

The problem is that I dont know how to write "B23 to B50" in a format Excel will understand.

View 12 Replies View Related

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

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 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

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

Compare Version Number Strings

Dec 13, 2006

I have two numbers, they are version numbers, I am having problems with my If then else and elseif statements.

59821 for version 5.9.8.2.1
is more than
5983 for version 5.9.8.3

even though 5.9.8.3 is a greater version number. Do you see where my problem is. How do I compare # by # reading it, checking to see what one is bigger and going from there. so when it gets to the 3 of the 5983 its bigger than 2 of 5982 of the 5.9.8.2.1

View 2 Replies View Related

Compare (divide) Cells If Date In Corresponding Cells Are Equal?

Aug 6, 2013

I have two sets of data to compare. One is real world data, the other is forecasted data. I have real daily data for every day over about 3 months. The predictions though, there may be 4-6 predictions for ever one real daily value.

What I'd like to do is have a function that looks at Column A's date (real daily value) and Column C's date (predicted data) and if Column C equals Column A, then divide corresponding data in Column B by value in Column D.

View 2 Replies View Related

Macro To Compare Date In Number And Product

Feb 17, 2014

I have another problem with my previous file that I need to finish. Because I want to make it clear I'll attach the files and pictures before the middle, and what can be the end of this table.

View 9 Replies View Related

Compare Number Lists On Different Sheets And Delete Duplicates

Mar 26, 2011

Need to find a column of numbers from one worksheet and delete them from another.

Example
To be deleted is below:
83221
83223
83232
83233
83236
to be deleted from is below:
83221
83223
83226
83227
83228
83229
83230
83232
83233
83234
83235
83236

Another issues is that the worksheet that needs to have the numbers deleted from has 3 columns total so the whole row would need deleting, or if its easier I could replace the numbers with 0 and then sort and delete.

View 9 Replies View Related

How To Compare Data Of Two Columns And Show Number From A Third Column

Apr 16, 2014

How can I compare the data of two columns, and if the same, to show me the number from a third column? I upload a quick sample

View 4 Replies View Related

Nearest Number Match - Huge Data To Compare

Aug 2, 2006

i have two columns in tow seperate workbooks to be compared:

in say inp.xls, there is a column(COL A) containting a lot of entries(numbers) - roughly around 60,000. Now in the other workbook, say mem.xls, i have a smaller set of numbers in a colum(COL B) - roughly around 300.

Now, the problem is, COL B, has numbers which may or may not match with numbers in COL A.

* If there is a match(between COL A and COL B), the row number at the match in COL A.

* If there is no match, the row of the closest number (in COL A) before to the number in COL B.

Example:

ROW COL A-----> COL B---------->
1 2184058252 2184276560
2 2184058280
3 2184058296
4 2184058312
5 2184058320
6 2184773640
7 2184774216
8 2184774272
9 2184774424



Now, i want to find 2184276560 in COLA, since it is not there, i want it to return the row number of the closest(previous) viz. row 5(2184058320).

Now, since this is a huge comparision set, im wondering what is the best way to do it. Im using VBA....

View 9 Replies View Related

Compare Serial Number And Copy Data Range

Aug 2, 2006

I need to compare a S/n from a huge amount of datarows in sheet 1 with the s/n in a second worksheet.

If the s/n matches i need to copy the datarow from sheet 1 to sheet 2 next to the data allready existing in sheet 2. This removing the row from sheet 1.

If there is no match found in sheet 2, the row ha's to be copied to sheet 3, this also removing the datarow.

like:

sheet 1:

S/n -- name -- price

sheet 2:

S/n -- place -- stock

if match is found need to become:

S/n -- place -- stock -- S/n -- name -- price

if there is no match found data go to sheet 3.

View 5 Replies View Related

Compare Values From Cells To Shapes To Cells

Feb 18, 2010

In the attached excel file I have two macros that create hyperlinks:

1. BalloonToNumber - Creates hyperlinks from "Oval" shapes on sheet "Op60_1" to sheet1 (column D).

2. NumberToBalloon - Creates hyperlink scheme from sheet1 (column D) to sheet "Op60_1" "Oval" shapes.

In Q #1 my macro seems to skip some shapes on sheet "OP60_1" and I simply can not figure out why.

In Q #2 my macro creates hyperlinks to shapes that do not exist and hyperlinks to numbers that are not a "100%" match, IE: 182 and 82 would share the same hyperlink?

If you open the workbook and use the hyperlinks on sheet1 they will take you to sheet "Op60_1" and shape hyperlinks from sheet "Op60_1" take you to sheet1. On sheet "Op60_1" there are some red arrows indicating the shapes that get skipped when running the "BalloonToNumber" macro.
Shape color changes as the hyperlinks are selected from sheet1.....

View 8 Replies View Related

VBA Code To Compare Cells To Multiple Cells

Aug 24, 2012

So I have a sheet with 600 or so rows of data on a sheet called "Agent_Summary". On another sheet in the same workbook I have a list 20 peoples names. I am trying to find a way to look at the 600 or so lines on the Agent_Summary in column A and see if the name in that cell matches any of the 20 names from the "Team" Sheet. If the name on Agent_Summary is not found on the "Team" sheet then it clears the contents of that cell and moves on. Then it comes back and Deletes the blank rows. I can make it look for any 1 of the 20 names and the code works fine. How do I turn it into something that will look for any of the 20 names?

Here is my code to look for 1 of the 20 names that works great.

Code:
Sub Clean_up_Agent_Summary()
Dim Cell As Range
Dim R As Long
Dim RE As Object
Dim Rng As Range
Set Rng = Worksheets("Agent_Summary").Range("A5:A600")
Set RE = CreateObject("VBScript.RegExp")

[Code]...

"Worksheets("Team").Range("A5")" is where my 1 name is and the rest are just below that. I am thinking some kind of an Array but I am stuck on getting that set up and working right.

View 6 Replies View Related

Join Cells & Compare To Single Cells

Jul 5, 2007

i've put this previously on here with no results. There is a formula already in there though does not work because what I want to achieve is to have Column A & Column C to Match Column E & Column F, to Return the Value YES or NO. I�ve Highlighted in ROW 947 one that should Say NO yet Says YES.

View 3 Replies View Related

Compare General Number To Date - Display Based On Criteria

Apr 29, 2007

I would like to create a formula that compares a number in one cell to the dates I have displayed in two different cells. If true, then I want it to display the Currency value from another cell.

______A________B________C________D_____
|1| Due Date | Amount | 1/01/2007 | 1/15/2007
|2|___4________$98_______________________

A2 is the DAY it's due
B2 is the AMT that is due

I can create an IF...THEN statement where if A2 is >= C1 BUT less than D1 then the value is B2, BUT it only works if I change A2 to an actual date which means i have to change it every month...which would not help with forecasting future transactions. So in the example above, the value would be in C2 and not D2.

View 9 Replies View Related

Cell Value Matches Value From Sheet1 - Compare Number From Cell2 And Show Difference?

Apr 26, 2014

Sheet1 is Main Sheet which never will be amended and these numbers will be a source for pulling mathematical functions

See attached :
Sheet1.png

Don't be bothered about cell colors etc. They are for my reference

Sheet2

Will contain same Problem Ticket numbers but different (or same) values with number of 'Linked Incidents'
See screenshot
Sheet2.png

Based on Problem ID 10248
Main sheet shows 92 Linked Incidents
Value on Sheet two brings 93

If A5 Sheet2 value can be found in ColumnA Sheet1, look for a number in ColumnC, same ROW and compare it to C7 in Sheet2 ?

Bring up difference value, which in this case would be one.

View 1 Replies View Related

Compare Our Item Number With The Suppliers Item Number?

Dec 18, 2012

I am using Vlookup to compare our item number with the suppliers item number but the result is removing the decimal point on some but not all items.I have included a small sample but it concerns almost 10.000 items.

View 9 Replies View Related

How To Compare Two Cells

Aug 7, 2013

I have two cells which contain text, and I'd like to use IF function to compare between them. Something like: =(IF(A1=B1),"TRUE",FALSE"). But it seems like the function cannot do it with text..

View 3 Replies View Related







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