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