I am trying to use a single cell to do multiple IF statments from another chart on the same sheet. For some reason the first two IF statements work but the rest after DO NOT want to work. What am I doing wrong, will shoot some FG your way for answers.

Formula I am using currently:

=IF(N10<=5,Q17,IF(N10>=6,Q16,IF(N10>=8,Q15,IF(N10>=10,Q14))))

Thanks,
Brock101

I think your issue arises from the fact that your first two if statements capture all possible values of N10 expect for those between 5 and 6, non-inclusive.

For example, your third nested if will never execute because if N10 >= 8, it must also be >= 6, so the second if will execute before reaching the third.

This post was edited by MidnightRider on Dec 8 2013 07:40pm

Thank you for your help, always need a second eye. I should of seen that lol, I just went with less than and its working perfect for what I need.

Thanks,
Brock101

Not to hijack your thread but your issue is fixed, and I also have an excel problem and this saves creating a new thread-

I have a header sheet that does a summary of all the other sheets, and I'm looking for a dynamic way to grab the sheet name via the contents of a cell on the header sheet:



works, however I want it to be dynamic in the sense that column a is a varying value.



is essentially what I want to happen, however I know that doesn't work. What I currently have is:



which also works, but I cannot get it to reference the cell !F6 within the INDIRECT result, it just won't work in any syntax I try.

This is theoretically what I think would make it work, but it doesn't work.


Any ideas?

"Not to hijack your thread but that's exactly what I'll do" - Ministry

This post was edited by Eagl3s1ght on Dec 9 2013 08:46am

but your issue has been resolved.

Nutted it out anyway.