How to Use the Excel =MOD() Function and What Are Its Use Cases?

แชร์
ฝัง
  • เผยแพร่เมื่อ 17 ต.ค. 2024

ความคิดเห็น • 5

  • @evgeniyutah55
    @evgeniyutah55 2 ปีที่แล้ว +3

    Thank you. Great explanation. Simple and easy to understand

  • @niabride7636
    @niabride7636 2 ปีที่แล้ว

    Your were right, I wasn't fan of this function, but now I see how many issues can it solve. Thank you very much

  • @CadetFord2345
    @CadetFord2345 2 ปีที่แล้ว +1

    If all pulls start from the top (the starting cherry), wouldn't 35 moves land on the bell below his ice cream? If he wants 19 moves to = 19, then the starting cherry could be considered position 19, correct? 20 moves to position 1, 21 moves to position 2 (the 2nd cherry). 18 moves, starting at the top, would land on the last symbol, MOD(18-1,19)+1=18th position. So MOD(35-1,19)+1=16th position. Very happy for the video and explanation, but just trying to make sure I understand and follow along correctly - anyone feel free to correct me if misunderstood something. Love the content, thanks!

  • @Sasikumar-l6z
    @Sasikumar-l6z หลายเดือนก่อน

    how to highlight in the decimal number
    12.145 = 0.145(Highlight this only)

  • @excelpro365_1
    @excelpro365_1 2 ปีที่แล้ว

    Can you please explain
    =LET(a,$A$3:$A$41,FILTER(a,a=CHAR(COLUMN(BM1)))) for me?
    Especially the BM1