Hi,

In my worksheet i have column of IDNo, which is starting from 001. In the
next cell downwards I m using a formula =IF(E60,B5+1,""). But when i search
any
digit like 50 throught ControF. the cursor goes to on 47. Same problem in
other
number search.

why is it.

Regards

Maybe the option the Find is using is "Look in: Formulas", so it has
gone to a cell with the formula containing 50 (eg =IF(E500,B49+1,""),
while the result of the formula is 47.

If this is the case then change to "Look in: Values"

Ken Johnson

Thank you Ken

yours

Rao

Thank you mam?sir?
Is there any way to enter =IF(E110,B10+1,"") this formula the number could
display like 002-2007 or 002-A

Regards
RRS


Maybe the option the Find is using is "Look in: Formulas", so it has
gone to a cell with the formula containing 50 (eg =IF(E500,B49+1,""),
while the result of the formula is 47.

If this is the case then change to "Look in: Values"

Ken Johnson

Rao Ratan Singh wrote:
Thank you mam?sir?
Is there any way to enter =IF(E110,B10+1,"") this formula the number could
display like 002-2007 or 002-A

Regards
RRS

Hi RRS,

Try these formulas...

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-2007","")

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-A","")

Sir:-) Ken Johnson

But how to enter first number by just 1 or 001-2007


"Ken Johnson" wrote:


Rao Ratan Singh wrote:
Thank you mam?sir?
Is there any way to enter =IF(E110,B10+1,"") this formula the number could
display like 002-2007 or 002-A

Regards
RRS

Hi RRS,

Try these formulas...

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-2007","")

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-A","")

Sir:-) Ken Johnson

Dear
I tried this formula but it is returning #value. I want to enter serial
number in this column by using formula in this manner 001-2007, 002-2007,
003-2007 and so on downwards.


"Ken Johnson" wrote:


Rao Ratan Singh wrote:
Thank you mam?sir?
Is there any way to enter =IF(E110,B10+1,"") this formula the number could
display like 002-2007 or 002-A

Regards
RRS

Hi RRS,

Try these formulas...

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-2007","")

=IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-A","")

Sir:-) Ken Johnson

Hi RRS,

I don't know the structure of your sheet, however, I typed '001 (ie
apostrophe zero zero one) into B10 and any positive number into E11.
Then, I entered =IF(E110,REPT("0",2-INT(LOG(B10+1)))&B10+1&"-2007","")
into A1 (can be any cell).

A1 then showed 001-2007.

If I then filled B10 down column B to produce 002, 003 etc, as well as
enter any old values into E12, E13 etc, filling the formula down in
column A resulted in either 004-2007 for example, when the precedent E
cell was 0 and blank cell when the precedent E cell was <=0.

I thought that was what you were after.

Ken Johnson