• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. E

    Excel and primenumbers

    Thanks Luke and everyone. Great help on this site! :)
  2. E

    Excel and primenumbers

    Wow, thanks everyone for your help. The formula ended up like this =OM(MIN(REST($B$3;RAD(INDIREKT("2:"&HELTAL(ROT($B$3))))))=0;"not prime";"prime") Translating the functions thanks to Meedan and Hui and replacing the "," with ";" like Hui said worked great! One somewhat of a crucial problem...
  3. E

    Excel and primenumbers

    I'm not sure where to check out which part of the formula excel not recognizing. When pressing "Show steps" excel just keeps underlining most of the formula.
  4. E

    Excel and primenumbers

    I tried your formula and did edit the cells to $B$3, that's about it. Now I got the problem "NAME?" instead. And yeah I'm hitting Ctrl Shift Enter after pasting the formula into the bar. Appreciating the help!
  5. E

    Excel and primenumbers

    Hey, sorry if this has been asked before, but I couldn't seem to find a post for it. I'm trying to use this array formula which I founded on this site, that tells if a number is a prime or not =IF(MIN(MOD($B$5,ROW(INDIRECT("2:"&INT(SQRT($B$5))))))=0,"not prime","prime"). I just can't get it to...
Back
Top