hey guys,....ive tried and tried to get this to work but cant wrap my head around how to make this come out right. i know what i need to happen but cant seem to make it work.

=if(and(L3="X",M3="X",N3="X"),DA3,=IF(L3="X",M3="",N3="X"),CP3,IF(L3="",M3="",N3="x","MANUAL",
im not even sure if im on the right track at this point.

heres what im trying to do

IF L3, M3,AND N3 ALL HAVE AN X, THEN I WANT THE VALUE OF DA3
IF L3 HAS AN X M3 IS BLANK AND N3 HAS AN X, I WANT THE VALUE OF CP3
IF L3 IS BLANK AND M3 IS BLANK AND N3 HAS AN X THEN I WANT THE WORD "MANUAL" IN THE CELL ANY OTHER CONDITIONS I WANT A ZERO

I JUST NEED THE FORMULA AND MAYBE A QUICK RUNDOWN OF HOW IT WORKS WITH MULTIPLE IFS,.....I UNDERSTAND THE CONCEPT BUT I CANT SEEM TO MAKE IT WORK WITH MORE THAN TWO IFS. THANKS IN ADVANCE