I am having problems figuring out the correct structure for this formula. I think my parentheses are not correct. Hope someone can assist. Thanks in advance.
=If(Or(And(N2=2,O2=2)), And(N2=2,O2=3)),"2",If(Or(And(N9=3,O2=2)),And(N2=3,O2=1)),"F3",If(Or(And If(And(N2=1,O2=1))),And(N2=1,O2=2)),And(N2=1,O2=3)),"1",If(And(N2=3,O2=3)),"3", If(And(N2=2,O2=1)),"F2","N/A")))
Last edited by berger01; 01-26-2011 at 10:59 AM.
Try:
Note if F2 and F3 are references to those cells, then remove the quotes.. also remove the quotes around the numbers if you want true numbers as results...
Please Login or Register to view this content.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi berger01,
Without looking at your full formula, I believe you need to use all CAPS with OR and AND.
If you have them capitalized in your formulas, let us know so looking further makes sense.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
If the syntax is correct (even in mixed case) then once you enter the formula it will automatically Uppercase the function names...Originally Posted by MarvinP
Well at least it did not error-out and thanks for quick response and the notes. The result for all (when copied down" is "N/A". F2 and F3 are not references to cells. So do you see anything else wrong with the formula?...
Example: This part of the formula: IF(AND(N2=3,O2=3),"3" is returning "N/A" when both criteria are met. Cells N2 and O2 are formated for Numbers. The active cell with this formula is formated to General to accept the "F2" etc.
Thanks Again!
Here is the updated formula as posted by NBVC.
=IF(OR(AND(N2=2,O2=2),AND(N2=2,O2=3)),"2",IF(OR(AND(N2=3,O2=2),AND(N2=3,O2=1)),"F3",IF(OR(AND(N2=1,O2=1),AND(N2=1,O2=2),AND(N2=1,O2=3)),"1",IF(AND(N2=3,O2=3),"3",IF(AND(N2=2,O2=1),"F2","N/A")))))
If I enter 3 in N2 and O2, I get a result of "3"... If I enter 2 and 2, I get "2", If enter 3 and 2, I get F3... so it seems to work.
Maybe it has to do with the other formulas in N2 and O2, but I wouldn't think so. Attached is the file with all formulas. I really appreciate and only need help with this formula. The columns reference are highlighted in Red and this formula resides in column "P" labled "TIER"
Thanks so much.
Last edited by berger01; 01-26-2011 at 11:06 AM.
Take away all the quotes from around the numbers in the formulas in column O and column P. They are inconsistent with formula in N.
NBVC: You Rock! All are working now, thanks so much and have a great day!
Last edited by berger01; 01-26-2011 at 10:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks