DEC2BIN.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. <?php
  2. return [
  3. ['101100101', '357'],
  4. ['#NUM!', '512'], // Too large
  5. ['#NUM!', '-513'], // Too small
  6. ['1001', '9, 4'],
  7. ['00001001', '9, 8'],
  8. ['001001', '9, 6.75'], // Leading places as a float
  9. ['#NUM!', '9, -1'], // Leading places negative
  10. ['#VALUE!', '9, "ABC"'], // Leading places non-numeric
  11. ['11110110', '"246"'],
  12. ['#NUM!', '12345'],
  13. ['#NUM!', '123456789'],
  14. ['1111011', '123.45'],
  15. ['0', '0'],
  16. ['#VALUE!', '"3579A"'], // Invalid decimal
  17. ['#VALUE!', 'true'], // ODS accepts boolean, Excel/Gnumeric don't
  18. ['#VALUE!', 'false'], // ODS accepts boolean, Excel/Gnumeric don't
  19. ['1110011100', '-100'], // 2's Complement
  20. ['1110010101', '-107'], // 2's Complement
  21. ['1000000000', '-512'], // lowest negative
  22. ['111111111', '511'], // highest positive
  23. ['#NUM!', '-513'],
  24. ['#NUM!', '512'],
  25. ['0011', '3, 4'],
  26. ['#NUM!', '3, 0'],
  27. ['#NUM!', '3, -1'],
  28. ['#NUM!', '3, 14'],
  29. ['#NUM!', '3, 1'],
  30. ['11', '3, 2'],
  31. [101, 'A2'],
  32. ['#VALUE!', '"A2"'],
  33. [0, 'A3'],
  34. ['exception', ''],
  35. ];