Hi,

I don't understand this.
What value do you have in A2752? Give examples of other values.
What value do you expect the formula to output?

Mike

"mcp201" wrote:

I have an IF statement formula already and I wanted to know if I could insert
another one, inserting certain numbers.

Example:
1101(data coming in) and I want to insert 310(for every one) in
front while picking up the first four digits. The problem is that the data
coming in is not always consistent.

Below is my IF Statement:

=IF(ISERR(VALUE(LEFT(A2752,1))2),H2751,IF(VALUE(L EFT(A2752,1))2,VALUE(LEFT(A2752,4)),VALUE(LEFT(A2 752,2))))

Thanks in advance.