need help formulating

**duhbiyung** · 04-13-2011, 09:42 PM

Hi,
I am having an assignment that requires excel to solve. I have 8x2 range cells, lets say A1:B8
The contents in A1:A8 are binary (0 or 1) in a random order, lets say 1 1 0 0 1 1 0 1. The contents in B1:B8 are also binary, they must check the corresponding cell above, if the value is 1 and cell before is 0 then the value in Bx is 1, otherwise 0. So in other words, the value of B1:B8 will be 1 0 0 0 1 0 0 1. Note that A1 and B1 is always 1.
If I'm using formula, the value of B2 will be =IF(AND(A1=0,A2=1),1,0), and copy to the rest of B. But the problem is I am not allowed to use any IF function. So it should be based on mathematical operation (+ - x /). Anyone can solve this?Thanks a lot

**teylyn** · 04-13-2011, 09:48 PM

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.

PLEASE PM WHEN YOU HAVE DONE THIS AND I WILL DELETE THIS POST

need help formulating

LinkBack

Thread Tools

Rate This Thread

Display

need help formulating

Re: need help formulating

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions