What is wrong in formula.
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
|