How To Handle Large Numbers?

B

bw

A3 = 123456789012
MOD(A3,10) = #NUM!

How do I handle situations like this when numbers are large? Why does it
make any difference what size the number is?
I want to be able to perform operations like this on 13 digit numbers
(unless you suggest a better way).

Thanks,
Bernie
 
F

Frank Kabel

Hi
this is a known bug of the MOD function. One possible workaround
=A3-INT(A3/10)*10
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel should be able to compute the MOD of large numbers. 5
After I reset my Games they get scambled. Conditional Formatting orMacro messed up somewhere 1
LARGE & VLOOKUP 6
How to Combine two cells (numbers) but not add 7
'Cleaning Up' a Column of Data 1
How to determine the first 6 large numbers from a list? 4
Sized of numbers in slides 4
How do I return a cell contents in a large worksheet? 3

Top