Syntax help needed

blazzercat · #1 07-08-2009, 11:51 AM

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 · #2 07-09-2009, 02:19 AM

=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 · #3 07-09-2009, 09:44 AM

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

blazzercat · #4 07-09-2009, 02:15 PM

Thanks works great.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help needed :)	thechief55	PowerPoint	1	04-28-2009 01:25 PM
Tips needed on posting an Outlook Calendar on our Website.	misterbob	Outlook	1	07-28-2006 03:18 PM