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