if statement for multiple cells

**Marekw** · 03-06-2011, 11:03 AM

I am trying to use below metioned formula, unfortunatelly it calculates only data in cell i6 instead of the mentioned range i6:u6

{=IF(I6:U6=1,"Not Working",IF(I6:U6=2,"Partial",IF(I6:U6=3,"Other","ok")))}

I would really appriciate help in this matter.

Thank you.

**Blake 7** · 03-06-2011, 04:24 PM

Originally Posted by Marekw

I am trying to use below metioned formula, unfortunatelly it calculates only data in cell i6 instead of the mentioned range i6:u6

{=IF(I6:U6=1,"Not Working",IF(I6:U6=2,"Partial",IF(I6:U6=3,"Other","ok")))}

Say for example you have this formula in cell A1 and cell I6 = 1 and Cell J6 = 2 and cell K6 = 3 and the other cells in the range = 100. What do you expect/want to appear in cell A1?

Is there a raking system whereby you want the scan the range for 1, 2 and 3 and if all appear withing the range then choose 1?

It may help to describe what you want to achieve rather than post a formula. May be a good idea to upload a sample too describing what you want.

**scottylad2** · 03-06-2011, 04:56 PM

=IF(OR(I5:U5=1),"Not Working",IF(OR(I5:U5=2),"Partial",IF(OR(I5:U5=3),"Other","ok")))

Entered with Ctrl + Shift + Enter

This assumes only one possible answer, 1 or 2 or 3 or ok and not 1 & 2 & 3......if there's a possibility of more than one match then the If will take the order of the IF's in place, so in this instance if there was a 1 and a 2 you will get "not working" as it will take the first argument

hope that helps

PS my formula was based on the ranges I5:U5, obviously adjust to suit