LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 173
Default =LEN returns incorrect answer


In the following table, the LEN formula returns the incorrect number of
characters.

The first number 34,... is in cell b12, it's corresponding LEN formula to
the right in cell b13.
It is the only one that returns correctly, the rest of the table is
obviously inaccurate.

*** The numbers themselves are based on a "to the nth power" formula.

Does anyone know why this is happening?!?
Thanx......

34,596,000,000 11 =LEN(B12)
124,545,600,000,000 15 =LEN(B13)
448,364,160,000,000,000 18 =LEN(B14)
258,257,756,160,000,000,000 16 =LEN(B15)
12,654,630,051,840,000,000,000 18 =LEN(B16)
34,218,119,660,175,400,000,000,000 20 =LEN(B17)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
AutoFilter Top 10 - Incorrect Answer Rebecca_SUNY Excel Discussion (Misc queries) 1 November 4th 08 04:55 PM
Pmt formula returns incorrect answer Heinz Excel Discussion (Misc queries) 2 June 6th 08 01:10 AM
Excel 2007- formula =SUM(850*77.1) returns incorrect answer = 1000 Diane Excel Discussion (Misc queries) 5 October 22nd 07 08:43 AM
Formula incorrect answer Wanna Learn Excel Discussion (Misc queries) 3 February 19th 07 04:29 PM
Formula giving incorrect answer... Jambruins Excel Discussion (Misc queries) 3 February 25th 05 06:59 PM


All times are GMT +1. The time now is 03:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"