A worksheet contains four-digit numbers in column A. Each of the four digits has to be added and the result shown in column B. To do so, the four digits of a cell are extracted by the MID function and summed.
To determine the cross sum:
1. In a worksheet, enter a series of four-digit numbers in cells A2:A10.
2. Select cells B2:B10 and type the following formula: =MID(A2,1,1)+MID(A2,2,1)+MID(A2,3,1)+MID(A2,4,1).
3. Press <-Ctrl+Enter->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=MGnN_44kt7s
Hope You Like This Tutorial - Give Comments
To determine the cross sum:
1. In a worksheet, enter a series of four-digit numbers in cells A2:A10.
2. Select cells B2:B10 and type the following formula: =MID(A2,1,1)+MID(A2,2,1)+MID(A2,3,1)+MID(A2,4,1).
3. Press <-Ctrl+Enter->.
Watch the Video Tutorial - https://www.youtube.com/watch?v=MGnN_44kt7s
Hope You Like This Tutorial - Give Comments
No comments:
Post a Comment