Help with Formula

[Rob0424]

Can someone help me fix this formula:

=IF(LEN(D3)=14, 1+MAX(B$1:B2), "")

This formula is in cell B3, and is trying to create numbering sequence where it numbers the cells based on if the number of characters in the cells in Column D being 14 long. The characters in the cells in Column D are numbers but not actual numbers and should actually read as text.

 

[jasonb75]

When is the formula giving you an incorrect result? Your question might make sense to you because you know what you are trying to do, but for anyone else it is unclear without some examples to compare the actual / incorrect and expected results.

If it is when there are decimal values in the cells that are rounded by formatting then you would need to use the round function in your formula to equal precision, e.g.

=IF(LEN(ROUND(D3,2))=14, 1+MAX(B$1:B2), "")

however, that may not work correctly for all numbers.