Nested if function

[markswan111]

[h=2]hello guys, I am trying to use to nested if function for two logical tests, but it won't work on excel 2007 no matter what I try, it says invalid formula...[/h]

=IF(E2="mark",m7*.01, IF(E2="james",m7*.01 , "nothing "))

any one can help?​

 

[live_excel]

Your formula is right.Don't know why it's not working.Please attached an image.

 

[FDibbins]

Looks right to me...
=if(e2="mark",m7*.01, if(e2="james",m7*.01,"nothing"))

 

[markswan111]

it doesn't work and give me error messege "the formula you type contain an error"