In a7:
=CHOOSE(AND(A2>30,B2>30)*1+1,"fail","pass")
Copy down through A10, don't need a macro.
edit- added attachment![]()
In a7:
=CHOOSE(AND(A2>30,B2>30)*1+1,"fail","pass")
Copy down through A10, don't need a macro.
edit- added attachment![]()
Last edited by GeneralDisarray; 06-29-2012 at 10:28 AM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks