Rearrange (Formula) is expected to show results in the right line.
As shown in Excel the formulas search incorrect coordinates.
Thank you,
Rearrange (Formula) is expected to show results in the right line.
As shown in Excel the formulas search incorrect coordinates.
Thank you,
The values have 2 decimal places.
The format you have chosen has zero decimal places.
Reformat the cells to show the correct value.
And I think you need to explain your problem in more detail.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Sir, I'll find out accidentally typing the number
In C4
=IF(ISNUMBER(A4),IF(AND(LEN(INT(A5))<>LEN(INT(A4)),LEN(INT(A4))<>LEN(INT(A3))),"wrong",""),"")
Copy across to D
And down
Thank you sir but I Need result looking a column "E" and "F"
Sorry sir, I accidentally put it on C3, formula works correctly.
Thank you so much,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks