Using "if" formula

[B.Kellough]

Does anyone know of a way to use a "IF" formula to check for multiple criteria and if the first criteria isn't met then it looks for the second criteria, and so on; and once it finds the correct match then it would bring back the inputted result.

for example:

=if(b3."1","1")+if(b4,"2","2")+if(etc.

I know that formula isn't what I need but was hoping it would provide an example of what I'm trying to achive.

 

[Ruddles]

You probably wouldn't use IF. You could nest up to seven IFs but there are so many looking up, matching, indexing and choosing functions, you'd probably use one of those for the sake of simplicity. Why do you specifically want to restrict yourself to using IF? That's not really what it's best at doing.

Tell us what you're really trying to do!

 

[B.Kellough]

This is what I ended up using and this does work; but if anyone knows of a better formula, I'm always willing to learn.

=IF(D3=1,0,IF(E3=1,1,IF(F3=1,2,IF(G3=1,3,IF(H3=1,4,IF(I3=1,5,IF(J3=1,6,0)))))))

Thanks.

 

[Ruddles]

This will do the job if you can guarantee there will be at least one "1" in the range:-

=MATCH(1,D3:J3,FALSE)-1

If you can't guarantee that, then it needs to be wrapped up in some error checking:-

=IF(ISNA(MATCH(1,D3:J3,FALSE)),0,MATCH(1,D3:J3,FALSE)-1)

 

[B.Kellough]

WOW-

Yes sir that works great!

Thanks