If statement
Hello,
I am having some difficulty trying to code some if statements under a particular cell in excel 2007. Attatched is the text file with the pseudocode and explanation of what i wanted to program in order to meet certain rules.I have also attached a template of the form that I have been trying to modify with this code.
Thanks
Last edited by vargs; 06-29-2010 at 12:27 PM.
Hi
May pay to have another look at the items in the text file. The test for "missing" is repeated. Also, are these in priority order? If so, then the test for A2="gv" will mean that the last 2 conditions don't get evaluated. If the are not in priority order, then rearrange to establish the priority.
rylo
Hello,
I took another look at my pseudocode txt file and have revised it.
Attatched is the revised version and I have reestablished the priority of statements.
Thanks
Hi
Second last criteria is:
If (A2="gv" & a2<>"gv")
Doesn't make sense to me. It either is, or it is not, but it can't be both.
rylo
Ah I hope this can clear up the confusion,
the second to last criteria
If (A2="gv" & a2<>"gv")
If b2,c2,d2,e2,g2=" "
says that regardless if A2 is equal to "gv" or not, if one of the following cells are blank: b2,c2,d2,e2,g2, then the final output cell H2 will say "pending"
The first part of this statement may not even be necessary. The if statement could very well just be
If b2,c2,d2,e2,g2=" "
H2="Pending"
thanks
Last edited by vargs; 06-28-2010 at 08:22 AM.
Hi
Try this
rylo=IF(OR(B2="Missing",B2="Maintain"),B2,
IF(AND(A2="gv", B2="return",COUNTIF(C2:G2,"Save")>0),"save",
IF(AND(B2="return",COUNTIF(D2:E2,"save")+COUNTIF(G2,"save")>0),"save",
IF(AND(A2<>"gv",COUNTIF(B2:E2,"destroy")+COUNTIF(G2,"destroy")=5),"destroy",
IF(AND( COUNTIF(B2:E2,"")+COUNTIF(G2,"") > 0),"Pending",
IF(A2="gv",F2,"something not considered"
))))))
Thank you so much for your help and pacience with me.
It works as intended, I greatly appreciate everything that you have done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks