Syntax help needed

[blazzercat]

I need help with the following syntax:

If A3 is not blank and C3 has an X display the contents of N3 otherwise display 0.

Thanks again

[boutells]

=IF(A3="",0,IF(C3="X",N3,0))

There ought to be a way in Excel to do "if and" statements as in Visual Basic but I can't find them so in their absence, you have to use double if statements.

Could also be written

=If(A3<>"",IF(C3="X",N3,0),0)

[boutells]

Try =IF(AND(A3<>"",C3="X"),+N3,0)

[blazzercat]

Thanks works great.