| Number | Result | Formula |
| 0.01 | 0 | =FLOOR(A2,1) |
| 1.27 | 1 | =FLOOR(A3,1) |
| 5.97 | 5 | =FLOOR(A4,1) |
MAGIC TRICKS of FLOOR() in Excel
Suppose in a cell have 12345
If you sum all the character 1+2+3+4+5
=15
Again Add 1+5
=6
In FLOOR ()
| CELL | RESULT | FORMULA |
| 12345 | 6 | =A13-FLOOR(A13,9) |
Note:- If the sum equal to 9 result will show 0
No comments:
Post a Comment