Microsoft Office Forums - View Single Post - [Solved] Syntax help needed

Thread: [Solved] Syntax help needed

View Single Post

Old

07-09-2009, 02:19 AM

boutells

boutells is offline

boutells uses Windows Vista

Windows Vista boutells uses Office 2007

boutells uses Office 2007

Office 2007

Novice

Join Date: May 2009

Posts: 24

boutells is on a distinguished road

Default

=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)

Reply With Quote