=IF(OR(AND(H2<=100,I2<=10),AND(H2<=750,I2<=6)),"S1",IF(OR(AND(H2<=100,I2<=18),AND(H2<=750,I2<10)),"S2",IF(OR(AND(H2<=100,I2<=26),AND(H2<=750,I2<18)),"S3",IF(OR(AND(H2<=100,I2>26),AND(H2<=750,I2>18)),"S4"))))
i want value, not false, true or blank cell
Give "FALSE", WHY?
Last edited by medo82006; 05-20-2013 at 11:54 PM. Reason: Change Title
Please change your thread title to meaningful heading so that we can able to give suggestion to your thread.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
well, without seeing the actual data, I would guess that the data does not meet any of the true conditions of the nested if, and as there is no value for the last false condition( (OR(AND(H2<=100,I2>26),AND(H2<=750,I2>18)),"S4") ), it returns the state of the argument of the test (FALSE), if you changed the last bit to this - (OR(AND(H2<=100,I2>26),AND(H2<=750,I2>18)),"S4",""), it would return a blank instead ?
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Sorry Sixth..I guess I was writing my my answer when you replied
@ dredwolf,
No sorry and all, we are aware about us and it happens to every one of us...
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.
Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for your response, but i want value, not false, true or blank cell
your last if() is missing the "else" part....
=IF(OR(AND(H2<=100,I2<=10),AND(H2<=750,I2<=6)),"S1",
IF(OR(AND(H2<=100,I2<=18),AND(H2<=750,I2<10)),"S2",
IF(OR(AND(H2<=100,I2<=26),AND(H2<=750,I2<18)),"S3",
IF(OR(AND(H2<=100,I2>26),AND(H2<=750,I2>18)),"S4"))))
AND, just as a 'by the way', I explained why you got the false...no conditions meet the true parts of the nested if's, and the last false was not defined, so it returned a FALSE..(or 0, if you prefer); you just have to make sure all conditions get a answer in your nested if's...
Thank you for your response, but the same result the formula give "FALSE"
please look attach file
OK Im looking at your file. I see nowhere where you have that formula?
did you upload the correct file? you make reference to data in H&!, but there is no data in H or I?
look attach file
data.xlsx
That is not the same formula you showed us to begin with, but it has the exact same problem...your last IF() is missing the last part. we have already pointed this out to you a number of times....
=IF(AND(H2<=100,I2<=10),"S1",
IF(AND(H2<=750,I2>6),"S1",
IF(AND(H2<=100,I2<=18),"S2",
IF(AND(H2<=750,I2>10),"S2",
IF(AND(H2<=100,I2<=26),"S1",
IF(AND(H2<=750,I2>18),"S3",
IF(AND(H2<=100,I2>26),"S3",
IF(AND(H2<=750,I2>18),"S4",""))))))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks