TRUNC Changes?

  • Thread starter Thread starter David Hammond
  • Start date Start date
D

David Hammond

Apparently the TRUNC Function in Excel 2000 gives
different answer than the TRUNC Function in Excel 97. I
use it in a spreadsheet and it functions okay for all
numeric values. However, it also assumed a value of zero
for non-numeric entries (as I wanted it to do) and now it
doesn't respond similarly but I can't find any
documentation that helps. Any ideas?
 
David Hammond said:
Apparently the TRUNC Function in Excel 2000 gives
different answer than the TRUNC Function in Excel 97. I
use it in a spreadsheet and it functions okay for all
numeric values. However, it also assumed a value of zero
for non-numeric entries (as I wanted it to do) and now it
doesn't respond similarly but I can't find any
documentation that helps. Any ideas?
Click to expand...

It *ALWAYS* helps if you mention *EXACTLY* how something doesn't work. If
you mean TRUNC returns #VALUE! when fed nonnumeric text in XL2K but not
XL97, then the most likely explanation is that you have Transition Formula
Evaluation enabled in XL97 but not XL2K. Tools > Options, Transition tab to
check their respective settings. Do they differ?
 
-----Original Message-----


It *ALWAYS* helps if you mention *EXACTLY* how something doesn't work. If
you mean TRUNC returns #VALUE! when fed nonnumeric text in XL2K but not
XL97, then the most likely explanation is that you have Transition Formula
Evaluation enabled in XL97 but not XL2K. Tools > Options, Transition tab to
check their respective settings. Do they differ?


.
Harlan
Click to expand...
Thanks so much for your help. Indeed the Transition
Formula was not enabled on the new version. Thanks once
again. If I ever get the chance, I would be pleased to
buy you a cold one.
David
 
Back
Top