Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
AutoFilter Top 10 - Incorrect Answer | Excel Discussion (Misc queries) | |||
Pmt formula returns incorrect answer | Excel Discussion (Misc queries) | |||
Excel 2007- formula =SUM(850*77.1) returns incorrect answer = 1000 | Excel Discussion (Misc queries) | |||
Formula incorrect answer | Excel Discussion (Misc queries) | |||
Formula giving incorrect answer... | Excel Discussion (Misc queries) |