#1
|
|||
|
|||
Syntax help needed
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 |
#2
|
|||
|
|||
=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) |
#3
|
|||
|
|||
Found the and syntax
Try =IF(AND(A3<>"",C3="X"),+N3,0)
|
#4
|
|||
|
|||
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 |