LinkBack URL
About LinkBacks
Hi All ,
i am trying to show chess moves in a excel file. I have created a sample move for Bishop by using Aboslute Distance Logic .
Can any one please help me getting KiNG & QUEEN move .
I would be really thank full to you.
Hi All ,
i am trying to show chess moves in a excel file. I have created a sample move for Bishop by using Aboslute Distance Logic .
Can any one please help me getting KiNG & QUEEN move .
I would be really thank full to you.
For king-
For Queen-
Please Login or Register to view this content.
Please Login or Register to view this content.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Thanks a lot Sir .
Can you just give me the logic ? Thought process behind your thinking.
Can you please explain the logic. Just one logic would work.
Moreover, cant we make it simple by just Absolute & AND functions
KING
Formula-
This formula returns TRUE if an one of the following conditions satisfy-Please Login or Register to view this content.
1. AND($B3=$A$1,C$2=$B$1)
This checks if the cell is the position where the king is currently residing.
2. AND(ABS(C$2-$B$1)=1,ABS($B3-$A$1)=0)
This checks if the cell is one box to the right or to the left of the current position of king. This is because if it would be one box towards the right or left, difference between x coordinates will be 1 and for y it will be zero.
3. AND(ABS(C$2-$B$1)=0,ABS($B3-$A$1)=1)
This checks if the cell is one box upwards or downwards of the current position of the king. This is because if it would be one box up or down, difference between y coordinates will be 1 and for x it will be zero.
4. AND(ABS(C$2-$B$1)=1,ABS($B3-$A$1)=1))
This checks if the box is one box away diagonally. This is because if the box is one box diagonally then x distance would be 1 and y distance would also be 1.
This thus covers all the possible positions of the king.
Similarly for the queen, instead of using distance to be equal to 1 box, it can be any distance, so the condition of distance equal to 1 is replaced by condition of distance <>0 i.e. any distance not equal to zero. And the last condition of 1 step diagonally as used in the king, has been changed to the condition you used for the bishop.
I hope this makes it more clear
Hi
Try these formula to get the movements of Bishop, Queen, King, Tower and Horse
Formula:
Please Login or Register to view this content.
See the file Chess Moves.xlsx
You can move the Chess table but you must select from $B$3
Hi! I was wondering if you had the formula for the Knight (horse)? Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks