distinguishing between 3 values and returning another value based on cell values/column

Hi,

Assuming you want to test each cell in B5:B12 and return a result for each cell in say C5:C12 then one way would be - in C5 copied down

Formula:

Please Login or Register  to view this content.

Hi Richard

I do not need to look at each cell just the column B5:b12 as only one cell will contain a value...usually an 8 or a 12 but the odd time a 4 or 5. I would like to then return the value entered in rangeB5:B12 in cell B13.

Maybe try using COUNTIF()?

=IF(countif($B$5:$B$12,8)>0,.75,if(countif($B$5:$B$12,12)>0,11.25,b5))

You have a range of 8 cells, which 1 of those would you want?

Yes I understand that part

However, you are looking in a range of 8 numbers and testing to see if any of them contain your criteria - if they do, return 1 of 2 values. So lets say your data looks like this - there is no 8 or 12, which value do you want?

	B
5	1
6	2
7	3
8	4
9	5
10	6
11	7
12	9

Hi Ford

Sorry I guess I am not explaining this right...or I don't understand. I have a 14 day pay period that runs across the top and a list of departments down the side. For each day, I plot an 8 or a 12 in the corresponding department that the individual worked in


There is only one entry per day but the department is what changes.I have it returning the correct hours for these two values(8 &12) but if I put a 4 in the department that the individual works I want it to just return the 4. I just want to look in the day and determine which department was worked in

The joys of text communication lol

Perhaps it would be better if you uploaded a small sample workbook, showing what you have and what you want?