Nesting IF formulas

Hi there

I am trying to nest IF formulas, but to no avail I am afraid.

I have a number of codes which needs to be matched with an account code

Example:

I040 = 3908
I026 = 3101
etc
etc

If no match value should be 0. I tried below string but got an error message.

=IF(E2="I040",3908),IF(E2="I026",3101,0))

What am I doing wrong here? Can I use some other logical formula?

Thanks and best regards

Mackan 7695

You don't need the close-bracket after the 3908:

=IF(E2="I040",3908,IF(E2="I026",3101,0))

Hope this helps.

Pete

Thanks Pete! It was bracket that needed to go!!

Brgds,

Mackan 7695