Returning a number if condition is true formula

Gerald Higgins

Well-known Member

Joined

Mar 26, 2007

Messages

9,258

• Oct 15, 2010

• #2

Hi.

Your request is confusing.
1233 is (almost) always equal to 1233.

You've given us a sample of input data.
Can you show EXACTLY what the output data should be, for that entire set ?

 

Upvote 0

D

Dohko

Board Regular

Joined

Apr 13, 2007

Messages

88

• Oct 15, 2010

• #3

Basically I have two people rating a certain item.
But not all items are rated by two people.
So only the one's that say Special have a second rater.
When that happens the Idno would be the same.
Basically I need to be able to say that if the Idno's match, I need to display the equivalent number corresponding to the color selected.
However I need two formulas one for when the review is Normal and when it's special.
In this case they are both the same color so will return the same number but that might not be the case all the time.

 

Upvote 0

Gerald Higgins

Well-known Member

Joined

Mar 26, 2007

Messages

9,258

• Oct 15, 2010

• #4

That doesn't really help much I'm afraid.

Same question again.

Gerald Higgins said:

Hi.
You've given us a sample of input data.
Can you show EXACTLY what the output data should be, for that entire set ?

Click to expand...

 

Upvote 0

D

Dohko

Board Regular

Joined

Apr 13, 2007

Messages

88

• Oct 15, 2010

• #5

I added another entry to make it clearer. Also added how the output will look

studyID Reviewr ID Color
A Normal 1233 Blue
R Special 1233 Blue
A Normal 1234 Red
B Normal 2222 Red
R Special 2222 Red
B Normal 2228 Yellow
C Normal 3859 Yellow
R Special 3859 Black
C Normal 3477 Black
D Normal 4447 Green
D Normal 4448 Green
R Special 4448 Green
E Normal 7777 Yellow
R Special 7777 Green

Normal Special
1 1
2 2
5 5
3 4

 

Upvote 0

Gerald Higgins

Well-known Member

Joined

Mar 26, 2007

Messages

9,258

• Oct 15, 2010

• #6

OK. So can you explain how, exactly, that output is derived from that input ?

 

Upvote 0

D

Dohko

Board Regular

Joined

Apr 13, 2007

Messages

88

• Oct 15, 2010

• #7

I will write in Pseudo code, since what I'm asking is how to do it in Excel.

So to calculate the first line it would be something like this.
Assuming the following
Let's say Blue=1, Red=2, Yellow=3,Black=4, Green=5


If ID's are equal, study is Normal, and Color is Blue Returns a 1.
If ID's are equal, study is Special, and Color is Blue Returns a 1.

If ID's are equal, study is Normal, and Color is Yellow Returns a 3.
If ID's are equal, study is Special, and Color is Blue Returns a 5.

I do need to check the whole column since I won't know the size of it.
If this feasable with a formula? Or vBA?

 

Upvote 0

D

Dohko

Board Regular

Joined

Apr 13, 2007

Messages

88

• Oct 18, 2010

• #8

any ideas?

 

Upvote 0

DonkeyOte

MrExcel MVP

Joined

Sep 6, 2002

Messages

9,124

• Oct 18, 2010

• #9

x-posted: http://www.excelforum.com/excel-general/749718-multiple-conditions-formula.html

 

Upvote 0