do you always want to increase +5?
further, what is in L11?


--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis









"soni" wrote:

I have set up a formula to add values to a cell based on other criteria.
However, the cells all have an alpha/numeric value such as M413351100001.

I want to take cell a1 with a value of M513343900001 and increase that
number by a certain value. The formual I have works fine if the cell has
only numeric values. How do I get it to ignore the first character in the
cell (it is always the first character)? In the example above, I want the
new value to be M5133439000006

=IF(N11=1,L11,IF(N111,L11+N11-1))

Thanks-
--
Soni