Adding a conditional IF to other IF statements

To know how to solve this one, you need to get your logic clearly understood. I have interpreted your description as:

If N65 isn't blank then:

((H65+I65+N65)*10)

otherwise (i.e. N65 is blank)

if C65 = "ns" then:

-1

otherwise (i.e. c65 doesn't equal "ns")

if L65=0 then

"NA"

otherwise

""

I tend to draw little tree diagrams to help me understand the logic when it gets tortuous...
If the above, then just put the last IF in instead of the "".

Please Login or Register  to view this content.

If it's not the above, then we can only help you once we fully understand the logic.

A couple of other observations.
Firstly, COUNTA() on one cell - presumably that's just to see if it's blank or not. You can use NOT(ISBLANK(N65)) for the same thing which is longer, but much easier for other people to understand.
Secondly, do you want the value "NA" or the error #N/A? If the latter, you can put the function NA() in your formula and it will generate the error code instead of text.

Duh. Missed that line! Always listen to the Guru....

PROBLEM SOLVED! Thanks to you both for the responses and DonkeyOte your revision is correct given the information I supplied. However I'm afraid I left something out. The reason I was wondering about the ability to add an extra "IF" is that I was trying to avoid the "NA" showing on rows that had no data entered yet. (Can't, as far as I know, hide them with conditional formatting the text because I'm using formula to shade every other line) With both responses pieced together I ended up with:

Please Login or Register  to view this content.

Which works perfectly! Thankyou very much!