Thread: Overflow puzzle
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Myle David Myle is offline
external usenet poster
  
Posts: 11
Default Overflow puzzle
Hi all,

My VBA editor returns a Run time overflow error for 300*8520000
but calculates without any fuss
2556*10^6
Yet both figures are the same viz: 2556000000
The same editor has no problem evaluating 2556*10^300

What gives?


Reply With QuoteReply With Quote