Formula not working. Please help

I have a worksheet with Local and Natl in the same column, I have have created an empy column and want the formula to give me a L if D6 says Local and a N if it says Natl but leave a blank if niether.

Please help

Thanks

Try

=IF(ISBLANK(D6),"",IF(D6="Local","L",IF(D6="Natl","N","")))

VBA Noob